On 1/3/21 10:27 AM, Thiemo Kellner wrote:
Quoting Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
Well, I guess, I can put the correct schema at installation, but
would have liked to have a more general approach. Furthermore, I
think this also implies that installation can only be done by psql. :-s
Why not grab the CURRENT_SCHEMA in the function?:
DECLARE
V_COUNT smallint;
C_SCHEMA varchar := CURRENT_SCHEMA;
Thank you all for your lightning fast replies. I failed to set it at
install time. \gset cannot be used as bind variables in SQL. So, I try
retaining the restriction to that the function needs to be installed in
the same schema as the triggered table.
Alright you lost me.
Can you provide an outline form of what you are trying to accomplish?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
