From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | James Gregory <james(at)anchor(dot)net(dot)au> |
Cc: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: trigger troubles |
Date: | 2003-03-20 04:10:22 |
Message-ID: | 20030319200912.O63485-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2003-03-20 04:14:43 | Re: Multiple backend connections |
Previous Message | Tom Lane | 2003-03-20 04:00:35 | Re: HELP: pg_clog file not found error |