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

From Jeff Eckermann
Subject Re: ERROR: CreateTrigger: function.....
Date
Msg-id 20030602133442.7309.qmail@web20803.mail.yahoo.com
Whole thread Raw
In response to Re: ERROR: CreateTrigger: function.....  (Richard Huxton <dev@archonet.com>)
List pgsql-general
--- Richard Huxton <dev@archonet.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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: check constraint
Next
From: "Ian Harding"
Date:
Subject: Re: Linked Servers