Re: Weird error message from Postgres 18 - Mailing list pgsql-hackers

From Ranier Vilela
Subject Re: Weird error message from Postgres 18
Date
Msg-id CAEudQAquxKYPrLGX4crPA-xsrbFgaOK1TMgisAKaARraba3umg@mail.gmail.com
Whole thread Raw
In response to Re: Weird error message from Postgres 18  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers


Em qui., 21 de ago. de 2025 às 12:17, Tom Lane <tgl@sss.pgh.pa.us> escreveu:
Ranier Vilela <ranier.vf@gmail.com> 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
> DETAIL:  Failing row contains (0, null, null, null).

You are misunderstanding the effects of that INSERT.  The AS labels
have zero to do with the semantics, so you are inserting 0 to col1,
null to col2 & col3, and by default null to col4.
Thanks for the clarification Tom.

best regards,
Ranier Vilela

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
Next
From: vignesh C
Date:
Subject: Re: Logical Replication of sequences