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

Поиск
Список
Период
Сортировка
От Ondrej Novy
Тема BUG #4750: UPDATE called from PL/pgSQL failed when there is ON UPDATE DO INSTEAD NOTHING rule
Дата
Msg-id 200904061405.n36E5BiT047100@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы 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>)
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Guillaume Smet
Дата:
Сообщение: Re: data loss with pg_standby when doing a controlled failover
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: data loss with pg_standby when doing a controlled failover