Ranier Vilela writes:
> create table inserttest (col1 serial PRIMARY KEY, col2 int4 NOT NULL, col3
> text NOT NULL, col4 text NULL);
> insert into inserttest select 0 AS col2, NULL AS col3, NULL AS col4;
> ERROR: null value in column "col2" of relation "inserttest" violates
> not-null constraint
Em qui., 21 de ago. de 2025 às 12:17, Tom Lane escreveu:
> Ranier Vilela writes:
> > create table inserttest (col1 serial PRIMARY KEY, col2 int4 NOT NULL,
> col3
> > text NOT NULL, col4 text NULL);
> > insert into inserttest select 0 AS col2, NULL AS col3, NULL AS col4;
> > ERROR: null value in