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.
Geoffrey KRETZ Four J's Development Tools
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
