| 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: | Whole Thread | Raw Message | 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
| 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 |