By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 14.24 (Debian 14.24-1.pgdg12+2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit |
SELECT 1
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
| relname | conname | coninhcount | convalidated |
|---|---|---|---|
| p1 | p1_a_check | 0 | f |
| p1_c1 | p1_a_check | 1 | t |
SELECT 2
ALTER TABLE
| relname | conname | coninhcount | convalidated |
|---|---|---|---|
| p1 | p1_a_check | 0 | f |
| p1_c1 | p1_a_check | 1 | f |
SELECT 2
DROP TABLE