where attname = 'a'

and (attrelid = 'p'::regclass

or attrelid = 'p1'::regclass

or attrelid = 'p11'::regclass);

or attrelid = 'p11'::regclass)

order by attrelid::regclass::text;

attrelid | attname | attnum

----------+---------+--------

p | a | 1

(1 row)

-- check that range partition key columns are marked NOT NULL

SELECT attname, attnotnull FROM pg_attribute WHERE attrelid = 'partitioned'::regclass AND attnum > 0;

SELECT attname, attnotnull FROM pg_attribute

WHERE attrelid = 'partitioned'::regclass AND attnum > 0

ORDER BY attnum;

attname | attnotnull

---------+------------

a | t

) PARTITION BY LIST (a);

CREATE TABLE part_a PARTITION OF parted FOR VALUES IN ('a');

-- only inherited attributes (never local ones)

SELECT attname, attislocal, attinhcount FROM pg_attribute WHERE attrelid = 'part_a'::regclass and attnum > 0;

SELECT attname, attislocal, attinhcount FROM pg_attribute

WHERE attrelid = 'part_a'::regclass and attnum > 0

ORDER BY attnum;

attname | attislocal | attinhcount

---------+------------+-------------

a | f | 1

where attname='a'

and (attrelid='p'::regclass

or attrelid='p1'::regclass

or attrelid='p11'::regclass);

or attrelid='p11'::regclass)

order by attrelid::regclass::text;

altertable p1 attach partition p11 forvaluesfrom (2) to (5);

SELECT relkindFROM pg_classWHERE relname='partitioned';

SELECT attname, attnotnullFROM pg_attributeWHERE attrelid='partitioned'::regclassAND attnum>0;

SELECT attname, attnotnullFROM pg_attribute

WHERE attrelid='partitioned'::regclassAND attnum>0

ORDER BY attnum;

DROPFUNCTION plusone(int);

CREATETABLEpart_a PARTITION OF parted FORVALUESIN ('a');

SELECT attname, attislocal, attinhcountFROM pg_attributeWHERE attrelid='part_a'::regclassand attnum>0;

SELECT attname, attislocal, attinhcountFROM pg_attribute

WHERE attrelid='part_a'::regclassand attnum>0

ORDER BY attnum;

CREATETABLEpart_b PARTITION OF parted (