Re: pg and number of parameters by insert

pginfo wrote:
 >
 > Hmm, Ok I try to explain:

Try again. I can't quite get what you mean.

 >If I write: insert into table_1  values ('f1_value',10);
 >
 >It is error because I try to insert 2 fields in 3-fields table. The
 >reason is that I can make write error.

If your table is:

create table_1 (
   a  text,
   b  int,
   c  int
);

Why should insert into table_1  values ('f1_value',10) be an error?

Explain to me why the above SQL query is wrong and maybe I can help you.
But I can't see why a DB should give an error. If you want to force the
user to give values for *every* column when doing an insert then all you
need to do is create a table like this:

create table_1 (
   a  text NOT NULL,
   b  int  NOT NULL,
   c  int  NOT NULL
);

Maybe I am missing your point?

Jc