| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | "Verhaag, G(dot)" <G(dot)Verhaag(at)lrcb(dot)umcn(dot)nl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: CreateTrigger: function..... |
| Date: | 2003-06-02 14:02:22 |
| Message-ID: | 8016.1054562542@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Richard Huxton <dev(at)archonet(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bodanapu, Sravan | 2003-06-02 14:23:58 | Re: Error while loading external data into Postgres table |
| Previous Message | erwan ancel | 2003-06-02 14:00:43 | Re: check constraint |