trigger troubles - Mailing list pgsql-general

From James Gregory
Subject trigger troubles
Date
Msg-id 1048170900.8571.1.camel@pirate.bridge.anchor.net.au
Whole thread Raw
Responses Re: trigger troubles  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Why does this not work? It's a plpython function if that changes
anything

perversity=# \df for*
                            List of functions
 Result data type |   Schema   |       Name        | Argument data types
------------------+------------+-------------------+---------------------
 text             | pg_catalog | format_type       | oid, integer
 "trigger"        | public     | foreign_key_check | text
(2 rows)

perversity=# create trigger f_foreign_key_check before insert or update
on f for each row execute procedure foreign_key_check ('f');
ERROR:  CreateTrigger: function foreign_key_check() does not exist
perversity=#

James.


pgsql-general by date:

Previous
From: Paul M Foster
Date:
Subject: Re: Multiple backend connections
Next
From: Tom Lane
Date:
Subject: Re: HELP: pg_clog file not found error