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)