Re: Fix example in partitioning documentation

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fix example in partitioning documentation
Date: 2019-09-24 02:14:42
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, Sep 24, 2019 at 10:52:30AM +0900, Amit Langote wrote:
> As of v12, Append node is elided when there's a single subnode under
> it. An example in the partitioning documentation needs to be fixed to
> account for that change. Attached a patch.

Indeed, using the same example as the docs:
CREATE TABLE measurement (
logdate date not null,
peaktemp int,
unitsales int
CREATE TABLE measurement_y2016m07
PARTITION OF measurement (
unitsales DEFAULT 0
) FOR VALUES FROM ('2016-07-01') TO ('2016-08-01');
SET enable_partition_pruning = on;
EXPLAIN SELECT count(*) FROM measurement WHERE logdate = DATE

I'll take care of committing that, however this will have to wait
until v12 RC1 is tagged.

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-09-24 02:33:35 Re: Custom reloptions and lock modes
Previous Message Michael Paquier 2019-09-24 02:07:16 Re: Add "password_protocol" connection parameter to libpq