Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group