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

From: "Ondrej Novy" <onovy(at)netbox(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule
Date: 2009-04-06 14:05:11
Message-ID: 200904061405.n36E5BiT047100@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4750
Logged by: Ondrej Novy
Email address: onovy(at)netbox(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas Pflug 2009-04-06 14:13:26 Re: data loss with pg_standby when doing a controlled failover
Previous Message Guillaume Smet 2009-04-06 13:51:33 Re: data loss with pg_standby when doing a controlled failover