Hi, On Mon, Dec 13, 2021 at 11:37 PM Ashutosh Sharma <ashu.coe...@gmail.com> wrote: > > Hi, > > Is this okay? > > postgres=# CREATE TABLE t1 (a int, b int) PARTITION BY LIST ( a, a, a ); > CREATE TABLE > > postgres=# CREATE TABLE t1_1 PARTITION OF t1 FOR VALUES IN ((1, 2, 3), (4, 5, > 6)); > CREATE TABLE > > postgres=# \d t1 > Partitioned table "public.t1" > Column | Type | Collation | Nullable | Default > --------+---------+-----------+----------+--------- > a | integer | | | > b | integer | | | > Partition key: LIST (a, a, a) > Number of partitions: 1 (Use \d+ to list them.)
I'd say it's not okay for a user to expect this to work sensibly, and I don't think it would be worthwhile to write code to point that out to the user if that is what you were implying. -- Amit Langote EDB: http://www.enterprisedb.com
