BUG #2089: Documentation bug: Triggers in plpythonu - Mailing list pgsql-bugs

From Jozef Behran
Subject BUG #2089: Documentation bug: Triggers in plpythonu
Date
Msg-id 20051202012353.E8B6BF0B6A@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #2089: Documentation bug: Triggers in plpythonu
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2089
Logged by:          Jozef Behran
Email address:      jozef.behran@krs.sk
PostgreSQL version: 8.1.0
Operating system:   Short answer: Mandrake 10.2. Long answer: Linux sarkan
2.6.11-6mdk #1 Tue Mar 22 16:04:32 CET 2005 i686 AMD Athlon(tm) Processor
unknown GNU/Linux
Description:        Documentation bug: Triggers in plpythonu
Details:

A trigger in plpythonu cannot use the `args' list to obtain the arguments
and does not return the row to be written into the database. Instead the
arguments are placed into a global dictionary called "TD". The row is in
TD["new"] as a dictionary keyed by the names of the fields (the values are
the values of the field). The trigger is supposed to return "SKIP" (or
None?) if it wants the operation to be skipped or modify the TD["new"] to
the actual content to be written into the database and then return "MODIFY".

pgsql-bugs by date:

Previous
From: "Dick Snippe"
Date:
Subject: BUG #2088: logfiles only readable by instance owner
Next
From: Tom Lane
Date:
Subject: Re: BUG #2087: Bogus error message on CREATE TRIGGER with a SQL function