Search Postgresql Archives

How to \ef a function ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
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 ?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux