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

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Geoffrey KRETZ <gk(at)4js(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PGS 7.2 : Insert with wrong number of values did not
Date: 2005-02-21 15:44:42
Message-ID: 1109000682.30529.59.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-02-21 15:47:35 Re: is there anyway to get the backends IP address from
Previous Message Magnus Hagander 2005-02-21 15:43:17 Re: Deadlock and FK triggers