Postgres Pro
Downloads
Home   >   mailing lists

Re: PGS 7.2 : Insert with wrong number of values did not - Mailing list pgsql-general

From Scott Marlowe
Subject Re: PGS 7.2 : Insert with wrong number of values did not
Date
Msg-id 1109000682.30529.59.camel@state.g2switchworks.com
Whole thread Raw
In response to PGS 7.2 : Insert with wrong number of values did not fail  (Geoffrey KRETZ <gk@4js.com>)
Responses Re: PGS 7.2 : Insert with wrong number of values did not
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Deadlock and FK triggers
Next
From: Geoffrey KRETZ
Date:
Subject: Re: PGS 7.2 : Insert with wrong number of values did not