Re: search_path for PL/pgSQL functions partially cached? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: search_path for PL/pgSQL functions partially cached?
Date
Msg-id CAFj8pRC70kmnPKhNCNJ9y+v3gRBTEUTpWs9kbTQL_c3i58QnEQ@mail.gmail.com
Whole thread Raw
In response to Re: search_path for PL/pgSQL functions partially cached?  (Jan Behrens <jbe-mlist@magnetkern.de>)
List pgsql-general
Hi


Maybe not many people run into these issues because schemas and
functions aren't used as often in combination?

I think schema and functions are common combinations. But when people have objects with the same name, then they are careful to be sure, so objects have really identical structure.
Using different types in these objects is very rare. And because Postgres doesn't support it well, experienced developers don't use it. Similar issues can do some issues after an stored procedures update, because can require session reset. Or when you need it, you can use a much more dynamic type like record.


Kind Regards
Jan Behrens


pgsql-general by date:

Previous
From: Jan Behrens
Date:
Subject: Re: search_path for PL/pgSQL functions partially cached?
Next
From: Gerhard Wiesinger
Date:
Subject: Re: Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo