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

From Geoffrey KRETZ
Subject Re: PGS 7.2 : Insert with wrong number of values did not
Date
Msg-id 421A0636.9000008@4js.com
Whole thread Raw
In response to Re: PGS 7.2 : Insert with wrong number of values did not  (Geoffrey KRETZ <gk@4js.com>)
List 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


pgsql-general by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: Deadlock and FK triggers
Next
From: Bo Lorentsen
Date:
Subject: Re: Deadlock and FK triggers