Re: trigger troubles

On 20 Mar 2003, James Gregory wrote:

> 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

Trigger functions should be created to return trigger and take no
arguments.  The arguments from create trigger are generally passed in
a different way (although I don't know what that is for plpython)