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