Re: using expression syntax for partition bounds

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: using expression syntax for partition bounds
Date: 2019-01-26 03:14:33
Message-ID: CA+HiwqEKfB1QRQ89jMZZtCz6-z7+3mqN5K=_T8Yt0kFeWTH4eQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Sat, Jan 26, 2019 at 12:01 Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Sat, Jan 26, 2019 at 03:14:51AM +0900, Amit Langote wrote:
> > How about replacing \d+ list_parted with couple of \d on individual
> > partitions, like in the attached?
>
> That would make it. Why just part_1 and part_3 though? It looks more
> complete to add part_null and part_2 as well.

The describe lines are there just to show that the stored expessions are
not verbatim same as the input expressions, so it seemed an overkill to add
them for all of the partitions.

Thanks,
Amit

PS: away from a computer, typing on the smartphone

>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-01-26 03:23:27 Re: pg_basebackup, walreceiver and wal_sender_timeout
Previous Message Morris de Oryx 2019-01-26 03:13:45 Re: crosstab/repivot...any interest?