Re: constraints & tableoid [pgsql8.1]

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: constraints & tableoid [pgsql8.1]
Дата
Msg-id 7380.1144763702@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: constraints & tableoid [pgsql8.1]  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: constraints & tableoid [pgsql8.1]  (姜维 <jw.pgsql@sduept.com>)
Список pgsql-bugs
Michael Fuhr <mike@fuhr.org> writes:
> Apparently a new row's tableoid isn't set until the row is actually
> inserted.

I believe that's true of all the system columns.  If you're using oid,
for example, that's not assigned either until heap_insert().

This behavior doesn't seem unreasonable to me.  A candidate row is not a
member of the table until *after* it's passed its constraint checks ---
until then, it's just some values sitting in memory.

            regards, tom lane

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: constraints & tableoid [pgsql8.1]
Следующее
От: 姜维
Дата:
Сообщение: Re: constraints & tableoid [pgsql8.1]