Postgres Pro
Downloads
Home   >   mailing lists

Re: SERIAL type, NOT NULL constraint and rule - Mailing list pgsql-bugs

From Tom Lane
Subject Re: SERIAL type, NOT NULL constraint and rule
Date
Msg-id 4134.1026225976@sss.pgh.pa.us
Whole thread Raw
In response to SERIAL type, NOT NULL constraint and rule  ("Tomis³aw Kityñski" <cromax@amiga.pl>)
List pgsql-bugs
Tree view 
"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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Insert aborted, but Sequence increased
Next
From: Bruce Momjian
Date:
Subject: Re: Insert aborted, but Sequence increased