MIME-Version: 1.0
From: intmail01 <intmail01@gmail.com>
Date: Tue, 9 Jan 2024 11:15:17 +0300
Message-ID: 
 <CAKJANSAW+2jQXxiZ8jeShHcsoKT_AhAk7HfQrNY+KgDxEC5Y0Q@mail.gmail.com>
Subject: How to use one function which can be accessed for all schemas
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b3015e060e7edd65"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKJANSAW%2B2jQXxiZ8jeShHcsoKT_AhAk7HfQrNY%2BKgDxEC5Y0Q%40mail.gmail.com>
Precedence: bulk

--000000000000b3015e060e7edd65
Content-Type: text/plain; charset="UTF-8"

Hi,

I have several schemas in my database, I want to create just one function
to use with all these schema.
I create the function in a main schema then the trigger call the function
and error occurs : "No function matches the given name and argument types.
You might need to add explicit type casts."

How to use just one function which can  be work amongst all shemas in the
db ?
My objective is to reduce update of functions code just once not for many
schemas. I dont want to duplicate my functions for each schema.

Thanks

--000000000000b3015e060e7edd65
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>I have several schemas i=
n my database, I want to create just one function to use with all these sch=
ema.</div><div>I create the function in a main schema then the trigger call=
 the function and error occurs : &quot;No function matches the given name a=
nd argument types. You might need to add explicit type casts.&quot;</div><d=
iv><br></div><div>How to use just one function which can=C2=A0 be work amon=
gst all shemas in the db ?<br></div><div>My objective is to reduce update o=
f functions code just once not for many schemas. I dont want to duplicate m=
y functions for each schema.<br></div><div><br></div><div>Thanks<br></div><=
/div>

--000000000000b3015e060e7edd65--