plpython trigger troubles.

Started by James Gregoryabout 23 years ago1 messagesgeneral
Jump to latest
#1James Gregory
james@anchor.net.au

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.