How to use one function which can be accessed for all schemas - Mailing list pgsql-sql

From intmail01
Subject How to use one function which can be accessed for all schemas
Date
Msg-id CAKJANSAW+2jQXxiZ8jeShHcsoKT_AhAk7HfQrNY+KgDxEC5Y0Q@mail.gmail.com
Whole thread Raw
Responses Re: How to use one function which can be accessed for all schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
How to use one function which can be accessed for all schemas  ("Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>)
List pgsql-sql
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

pgsql-sql by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Wich program generates "list index out of range" ? pgadmin or the server ?
Next
From: Maximilian Tyrtania
Date:
Subject: Problem with refcursor