Re: constraints & tableoid [pgsql8.1]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: ??? ??? <jw(dot)pgsql(at)sduept(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: constraints & tableoid [pgsql8.1]
Date: 2006-04-11 13:55:02
Message-ID: 7380.1144763702@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 姜维 2006-04-11 14:14:07 Re: constraints & tableoid [pgsql8.1]
Previous Message christian.koth 2006-04-11 12:47:33 BUG #2387: Incorrect sorting of timestamp with time zone