On 1/8/24 08:26, David Gauthier wrote:
atletx7-reg017:/home/dgauthie[ 120 ] --> dvdbdev
Pager usage is off.
psql (11.5, server 11.3)
Type "help" for help.
dvdb=# \df opid.bef_ins_axi_reqs_set_trig;
List of functions
Schema | Name | Result data type | Argument data
types | Type
--------+---------------------------+------------------+---------------------+------
opid | bef_ins_axi_reqs_set_trig | trigger |
| func
(1 row)
dvdb=# \ef opid.bef_ins_axi_reqs_set_trig;
ERROR: function "opid.bef_ins_axi_reqs_set_trig;" does not exist
Lose the ';'.
It should be:
\ef opid.bef_ins_axi_reqs_set_trig
dvdb=# \ef opid.bef_ins_axi_reqs_set_trig();
ERROR: expected a right parenthesis
dvdb=#
So the function exists with \df but not \ef ?
I get the need to identify the argument list (in case there's >1 with
same name, diff arg list), but '()' doesn't work. Does this have to do
with the returned trigger type ?
--
Adrian Klaver
adrian.kla...@aklaver.com
