Postgres Pro
Downloads
Home   >   mailing lists

BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule - Mailing list pgsql-bugs

From Ondrej Novy
Subject BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule
Date
Msg-id 200904061405.n36E5BiT047100@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Guillaume Smet
Date:
Subject: Re: data loss with pg_standby when doing a controlled failover
Next
From: Andreas Pflug
Date:
Subject: Re: data loss with pg_standby when doing a controlled failover