Re: BUG #5081: ON INSERT rule does not work correctly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5081: ON INSERT rule does not work correctly
Дата
Msg-id 22436.1253982918@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5081: ON INSERT rule does not work correctly  ("Stefan" <sb@drbott.de>)
Ответы Re: BUG #5081: ON INSERT rule does not work correctly  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-bugs
"Stefan" <sb@drbott.de> writes:
> The problem is that if it is no record in the table, it seems that first the
> INSERT command is issued and after that the UPDATE command is issued, too.

Well, yeah.  That's exactly how it's documented to work: an ON INSERT
rule is executed after the INSERT proper.

You could maybe make this work with a BEFORE INSERT trigger.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: [JDBC] BUG #5058: [jdbc] Silent failure with executeUpdate()
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5076: LEFT OUTER JOIN and WHERE madness