Re: How to \ef a function ? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to \ef a function ?
Date
Msg-id 1940933.1704732479@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to \ef a function ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to \ef a function ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 1/8/24 08:26, David Gauthier wrote:
>> 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

Yeah, that's what psql is expecting, but it does seem a bit
unforgiving considering that you can write a noise semicolon
in many other backslash commands.  And this:

>> dvdb=# \ef opid.bef_ins_axi_reqs_set_trig();
>> ERROR:  expected a right parenthesis

seems outright buggy.  I've not looked at the code though.

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Unable to install postgresql and pgadmin
Next
From: Tom Lane
Date:
Subject: Re: How to \ef a function ?