plpython trigger troubles.

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.

Browse pgsql-general by date

  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