BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule

Started by Ondrej Novyabout 17 years ago2 messagesbugs
Jump to latest
#1Ondrej Novy
onovy@netbox.cz

The following bug has been logged online:

Bug reference: 4750
Logged by: Ondrej Novy
Email address: onovy@netbox.cz
PostgreSQL version: 8.2.13
Operating system: Linux
Description: UPDATE called from PL/pgSQL failed when there is ON
UPDATE DO INSTEAD NOTHING rule
Details:

Hi,

create rule on table ON UPDATE DO INSTEAD NOTHING.
Then create function which calls UPDATE on this table.
ERROR: SPI_execute_plan failed executing query "...": Unrecognized SPI code
0
CONTEXT: PL/pgSQL function "..." line ... at SQL statement

Thank you,
Ondrej Novy

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ondrej Novy (#1)
Re: BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule

"Ondrej Novy" <onovy@netbox.cz> writes:

Description: UPDATE called from PL/pgSQL failed when there is ON
UPDATE DO INSTEAD NOTHING rule

This is fixed for 8.4, but the fix was deemed too invasive to
back-patch into existing branches.

regards, tom lane