| From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com>, "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 13:34:42 |
| Message-ID: | 20030602133442.7309.qmail@web20803.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- Richard Huxton <dev(at)archonet(dot)com> wrote:
> > CREATE suggest after the CREATE FUNCTION.....
> statement is being executed!
>
> Certainly does.
>
> > 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
AFAIR functions with return type of "opaque" or
"trigger" do not show up when using the \df command.
Try looking directly at the pg_proc system table.
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2003-06-02 13:51:09 | Re: Linked Servers |
| Previous Message | Bruno Wolff III | 2003-06-02 13:08:19 | Re: check constraint |