Re: Fix example in partitioning documentation

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Fix example in partitioning documentation
Дата
Msg-id 20190924021442.GE2012@paquier.xyz
обсуждение исходный текст
Ответ на Fix example in partitioning documentation  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Fix example in partitioning documentation  (Amit Langote <amitlangote09@gmail.com>)
Список 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
 ) PARTITION BY RANGE (logdate);
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
'2016-07-02';

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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Add "password_protocol" connection parameter to libpq
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Custom reloptions and lock modes