From: | Amit Langote <amitlangote09(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Peter Eisentraut <peter(at)eisentraut(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | Re: pgsql: Allow generalized expression syntax for partition bounds |
Date: | 2019-01-26 02:53:17 |
Message-ID: | CA+HiwqGPEzudQ6Y6nXyCOQbLk31S3EkSJMC9SH25nJtYwUwChA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
On Sat, Jan 26, 2019 at 11:05 Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> On Fri, Jan 25, 2019 at 10:37:22AM +0000, Peter Eisentraut wrote:
> > Allow generalized expression syntax for partition bounds
> >
> > Previously, only literals were allowed. This change allows general
> > expressions, including functions calls, which are evaluated at the
> > time the DDL command is executed.
> >
> > Besides offering some more functionality, it simplifies the parser
> > structures and removes some inconsistencies in how the literals were
> > handled.
>
> fulmar, magpie and treepie are unhappy after this commit, and all of
> them have the same complaint related to the order consistency of
> partitions showing up in psql:
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=magpie&dt=2019-01-25%2011%3A04%3A07
>
> Partition key: LIST (a)
> -Partitions: part_1 FOR VALUES IN (1),
> +Partitions: part_null FOR VALUES IN (NULL),
> + part_1 FOR VALUES IN (1),
> part_2 FOR VALUES IN (2),
> - part_3 FOR VALUES IN (3),
> - part_null FOR VALUES IN (NULL)
> + part_3 FOR VALUES IN (3)
Have sent the patch on the -hackers thread for this patch after Tom pointed
out one of these failures.
Thanks,
Amit
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2019-01-26 03:04:37 | Re: pgsql: Allow generalized expression syntax for partition bounds |
Previous Message | Tom Lane | 2019-01-26 02:15:10 | pgsql: Allow UNLISTEN in hot-standby mode. |