From: | James Gregory <james(at)anchor(dot)net(dot)au> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | plpython trigger troubles. |
Date: | 2003-03-24 14:34:37 |
Message-ID: | 1048516476.2893.3.camel@pirate.bridge.anchor.net.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
having some trouble with triggers. Defined a trigger like so:
create trigger "domain_orderitem_foreign_key_check" before insert or
update on domain_orderitem for each row execute procedure
foreign_key_check('domain_orderitem');
which calls a plpython function, the first line of which is:
create or replace function foreign_key_check () returns trigger as '
plpy.notice(''running foreign key check'')
ie - I should be seeing a message every time I insert or update on that
table. However, running
update domain_orderitem set domain_id = 147;
just sits there indefinitely. Why am I not seeing the notice message?
The function *should* "work" - but I don't think that's the problem. It
appears to be choking on the actual call.
What can I do to fix this?
thanks,
James.
From | Date | Subject | |
---|---|---|---|
Next Message | lists | 2003-03-24 14:45:38 | plpgsql and setting array values. |
Previous Message | Rahul | 2003-03-24 14:08:59 | Postgresql with krb5 |