Quoting Adrian Klaver <[email protected]>:
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. :-sWhy 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.
-- S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH Signal (Safer than WhatsApp): +49 1578 7723737 Threema (Safer than WhatsApp): A76MKH3J Handys: +41 78 947 36 21 | +49 1578 772 37 37
