Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version


PostgreSQL 15beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit



CREATE TABLE PKTABLE (
    tid int,
    id int,
    PRIMARY KEY (tid, id)
);
insert into pktable values(null,1);
ERROR:  null value in column "tid" of relation "pktable" violates not-null constraint
DETAIL:  Failing row contains (null, 1).


insert into pktable values(null,1);
ERROR:  null value in column "tid" of relation "pktable" violates not-null constraint
DETAIL:  Failing row contains (null, 1).


insert into pktable values(1,1);
1 rows affected

drop table pktable;
CREATE TABLE PKTABLE1 (
    tid int,
    id int,
    unique (tid, id)
);
insert into pktable1 values(null,1);
1 rows affected

insert into pktable1 values(null,1);
1 rows affected

insert into pktable1 values(null,null);
1 rows affected