pg and number of parameters by insert - Mailing list pgsql-general

From pginfo
Subject pg and number of parameters by insert
Date
Msg-id 3DEDBD08.DDB1CF1@t1.unisoftbg.com
Whole thread Raw
List pgsql-general
Hi ,

I am very confused with pg insert manipulation.

As I see pg don not check number of insert parameters and do not comapre
it to table column numbers.

For example if :

create table table_1 ( filed _1 name, field_2  int, field_3  name);

And if I try to execute:

insert into table_1 values ('f1_value',10);

I do not get any error from pg !!!

The problem is that I send two parameter and in table declaration I have
3 !

Is it bug by pg or I can setup my server to prevent my from this
mistake.

I make a litle test with oracle, MS SQL and mySQL and all this reports
error.

regards,
ivan.


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Postgresql -- initial impressions and comments
Next
From: Jean-Christian Imbeault
Date:
Subject: Re: pg and number of parameters by insert