Re: PGS 7.2 : Insert with wrong number of values did not

On Mon, 2005-02-21 at 09:49, Geoffrey KRETZ wrote:
> Scott Marlowe wrote:
>
> >On Mon, 2005-02-21 at 09:38, Geoffrey KRETZ wrote:
> >
> >
> >>Hi,
> >>
> >>I've got a question about a difference beetween PGS 7.2 and PGS 7.4
> >>behaviours.
> >>
> >>With PGS 7.2 :
> >> INSERT INTO table (col1, col2) VALUES (val1) doesn't fail
> >>
> >>With PGS 7.4 :
> >> INSERT INTO table (col1, col2) VALUES (val1) failed
> >>
> >>Is it a known bug ?
> >>
> >>
> >
> >Yes, if 7.2 did that it WAS a known bug.  Fixed in 7.4.  It is illegal
> >to have unmatching numbers of columns in the insert list and the column
> >list.
> >
> >Did 7.2 really do that?
> >
> >
> >
>
> 7.1 do that and while testing recently, we found that in 7.2, it's the
> same behaviour. In 7.3, it's already ok.
>
> I've answer the question just to be sure that it's a postgresql bug.


Note that in the old version, postgresql would have inserted a default
value or a NULL if there was no default.  With the addition of the
DEFAULT keyword, you can get the same basic effect with:

insert into table (col1, col2) values (val1,DEFAULT);