Re: ERROR: CreateTrigger: function..... - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: CreateTrigger: function.....
Date
Msg-id 8016.1054562542@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: CreateTrigger: function.....  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
>> However when I want to see whether it is really present I type \df
>> myfunctionsname(); within the psql interface, but without a positive
>> result! Any other user-defined function I create which doesn't have an
>> OPAQUE return type, does show up in the list of functions when I issue the
>> \dt-command!

> Difficult to say what's happening here - especially as you say you're happily
> creating other functions.

I think it's getting created but \df isn't showing it.  At one time \df
deliberately excluded functions that returned OPAQUE.  This isn't true
anymore as of 7.3 ...

            regards, tom lane

pgsql-general by date:

Previous
From: erwan ancel
Date:
Subject: Re: check constraint
Next
From: "Bodanapu, Sravan"
Date:
Subject: Re: [ADMIN] Error while loading external data into Postgres table