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