[SQL] table constraint + INSERT

Title: table constraint + INSERT Hello I use PostgreSQL in my program and I found a strange behavior, at least for me. I have a simple table with constraint CREATE TABLE "PART" (   "P_PARTKEY" int4 NOT NULL,   "P_RETAILPRICE" numeric,   CONSTRAINT "PART_PRIMARY" PRIMARY KEY ("P_PARTKEY"),

[SQL] Table constraints and INSERT

Hello I use PostgreSQL in my program and I found a strange behavior, at least for me. I have a simple table with constraint CREATE TABLE "PART" ( "P_PARTKEY" int4 NOT NULL, "P_RETAILPRICE" numeric, CONSTRAINT "PART_PRIMARY" PRIMARY KEY ("P_PARTKEY"), CONSTRAINT "PART_check" CHECK ("P_RET