Re: pg and number of parameters by insert

Hi,

I do not think so.

Realy I will to have NULL value in my table.
The problem is that it can be syntax error (for example I forgot to rewrite
all my functions after
adding new filed to my table).

In this case I have syntax error in my code!
And I think the pg need to report it.

If I write
insert into table_1 (field_1,field_2) values ('f1_value',10);
and field_3 is not declared as NOT NULL it will be correct for pg to execute
it without any massage.

Is it so?

regards,
ivan.

Jean-Christian Imbeault wrote:

> pginfo wrote:
> >
> > 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 reason is that you did not declare the fields to be "NOT NULL". The
> default is to allow null values into the fields unless you specifically
> create the columns with the constraint "NOT NULL".
>
> If you want an error to be thrown you need to create your table liek this:
>
> create table table_1 (
> filed _1 text NOT NULL,
> field_2 int NOT NULL,
> field_3 text NOT NULL
> );
>
> Jc