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

From Tom Lane
Subject Re: PGS 7.2 : Insert with wrong number of values did not fail
Date
Msg-id 557.1109003632@sss.pgh.pa.us
Whole thread Raw
In response to PGS 7.2 : Insert with wrong number of values did not fail  (Geoffrey KRETZ <gk@4js.com>)
List pgsql-general
Geoffrey KRETZ <gk@4js.com> writes:
> 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 ?

More a deliberate change in behavior.  The old behavior was intentional
but we decided it was too much at variance with the SQL spec.  Now you
can only omit columns when you don't specify a column name list.

            regards, tom lane

pgsql-general by date:

Previous
From: Jeremiah Megie
Date:
Subject: Unix Domain Socket Error
Next
From: Tom Lane
Date:
Subject: Re: Unix Domain Socket Error