Re: SERIAL type, NOT NULL constraint and rule

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tomis aw Kity ski" <cromax(at)amiga(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: SERIAL type, NOT NULL constraint and rule
Date: 2002-07-09 14:46:16
Message-ID: 4134.1026225976@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Tomisaw Kityski" <cromax(at)amiga(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-07-09 15:21:34 Re: Insert aborted, but Sequence increased
Previous Message Tomisaw Kityski 2002-07-08 20:01:33 SERIAL type, NOT NULL constraint and rule