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

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

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.

I've ASK the question (not answered it !!)

Sorry for the mistake :-/

Geoffrey

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bo Lorentsen 2005-02-21 16:14:02 Re: Deadlock and FK triggers
Previous Message Magnus Hagander 2005-02-21 15:53:44 Re: Deadlock and FK triggers