Restriction on table partition expressions

2022-08-25 Thread James Vanns
Hey PG community, PG version: 13 Platform: Linux I was wondering if anyone understands why there is the restriction/limitation on using expressions (on a primary/unique key) as part of a table partition definition. E.g. CREATE TABLE foobar( id BIGINT NOT NULL PRIMARY KEY, baz VARCHAR NUL

Re: Restriction on table partition expressions

2022-08-26 Thread James Vanns
s all partitions, then that is why it's forbidden. Cheers Jim On Thu, 25 Aug 2022 at 16:32, David Rowley wrote: > > On Fri, 26 Aug 2022 at 03:08, James Vanns wrote: > > Also, is there a chance that this > > limitation will be relaxed in the future? > > (forgot to answ