Re: SERIAL type, NOT NULL constraint and rule

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SERIAL type, NOT NULL constraint and rule
Дата
Msg-id 4134.1026225976@sss.pgh.pa.us
обсуждение исходный текст
Ответ на SERIAL type, NOT NULL constraint and rule  ("Tomis³aw Kityñski" <cromax@amiga.pl>)
Список pgsql-bugs
"Tomis³aw Kityñski" <cromax@amiga.pl> writes:
> So it seems, like action in the
> rule does not see "id_user" value set to default value in NEW
> tuple.

Yeah, this is a known bug in 7.2 and 7.2.1 --- ON INSERT rules fail to
see values inserted by DEFAULTs.  It's fixed in current development
sources, and if there's any movement to release a 7.2.2 (which so far
there hasn't been) I might back-patch it for that.

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Insert aborted, but Sequence increased
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Insert aborted, but Sequence increased