Re: [BUGS] INSTEAD rule bug?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] INSTEAD rule bug?
Дата
Msg-id 23479.1058288014@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
Ответы Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
Список pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> I know... That was a typo in my sql :-)
> But for this example it doesn't matter - that view/table is only needed
> to illustrate the rules behaviour on insert.

Oh, I see what you're on about.  Sorry, a "DO INSTEAD NOTHING" only
suppresses the original command, it does not suppress other rules.
I think what you want is to make the insert_test rule conditional
on x being not null.

            regards, tom lane

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: perfromance impact of vacuum
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Are you frustrated with PostgreSQL