Обсуждение: ERROR: CreateTrigger: function.....

Dear list-member,

I'm new to triggers, and want to try them! That's why I generated a function with plpgsql. Creating the function seems
towork, as the word CREATE suggest after the CREATE FUNCTION..... statement is being executed! 

However when I want to see whether it is really present I type \df myfunctionsname(); within the psql interface, but
withouta positive result! Any other user-defined function I create which doesn't have an OPAQUE return type, does show
upin the list of functions when I issue the \dt-command! 

As a result of the failure mentioned above, the CREATE TRIGGER doesn't work either!

Sorry, but I can't figure out what's the problem! Can anybody drop a line how to tackle this problem! By the way I'm
currentlyusing PostgreSQL version 7.2.2 on a PC running RedHat 8.0! Thanks in advance! 

Regards,

    Geert Verhaag

National Expert and Training Centre for Breast Cancer Screening (LRCB)
UMC St. Radboud / UMC Nijmegen
451, LRCB
P.O. Box 9101, 6500 HB Nijmegen, Netherlands
Tel: +31.24.36(17551/16706)
E-mail: g.verhaag@lrcb.umcn.nl

On Monday 02 Jun 2003 11:21 am, Verhaag, G. wrote:
> Dear list-member,
>
> I'm new to triggers, and want to try them! That's why I generated a
> function with plpgsql. Creating the function seems to work, as the word
> 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 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. Have you tried "\df abc*" where "abc" is the first
few letters of your function-name?

Perhaps see my (sadly out-of-date) PostgreSQL Notes at:
http://techdocs.postgresql.org/ and see if you can get one of the examples
there to work.

If you're still seeing problems, post the CREATE FUNCTION to the list and
we'll have a look.
--
  Richard Huxton

--- 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

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