| Lists: | pgsql-bugs |
|---|
| 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 |
| 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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Ondrej Novy" <onovy(at)netbox(dot)cz> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule |
| Date: | 2009-04-06 14:30:39 |
| Message-ID: | 28134.1239028239@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Ondrej Novy" <onovy(at)netbox(dot)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