Thread: 7.3 Doc Bug in plpython
The valid return value should be MODIFY instead of MODIFIED. The error message said so :-) In 25.3. Using PL/Python If the trigger "when" is BEFORE, you may return None or "OK" from the Python function to indicate the tuple is unmodified, "SKIP" to abort the event, or "MODIFIED" to indicate you've modified the tuple. should read If the trigger "when" is BEFORE, you may return None or "OK" from the Python function to indicate the tuple is unmodified, "SKIP" to abort the event, or "MODIFY" to indicate you've modified the tuple. elein@norcov.com
Patch applied. Thanks. --------------------------------------------------------------------------- elein wrote: > The valid return value should be MODIFY instead of MODIFIED. > The error message said so :-) > > In 25.3. Using PL/Python > > If the trigger "when" is BEFORE, you may return None or "OK" > from the Python function to indicate the tuple is unmodified, "SKIP" > to abort the event, or "MODIFIED" to indicate you've modified the tuple. > > should read > If the trigger "when" is BEFORE, you may return None or "OK" > from the Python function to indicate the tuple is unmodified, "SKIP" > to abort the event, or "MODIFY" to indicate you've modified the tuple. > > elein@norcov.com > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073