Re: Weird error message from Postgres 18

2025-08-21 Thread Tom Lane
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

Re: Weird error message from Postgres 18

2025-08-21 Thread Ranier Vilela
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