Re: [HACKERS] Partitions: \d vs \d+

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Partitions: \d vs \d+
Дата
Msg-id CA+TgmoY06OTxiHQK7_8GtehonCyyN8QRVe3CWxpnpEe_b46ycA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Partitions: \d vs \d+  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список pgsql-hackers
On Thu, Sep 28, 2017 at 9:33 PM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:
> Perhaps, there is no case when "No partition constraint" should be output,
> but I may be missing something.

The case arises when a partitioned table has a default partition but
no other partitions.

I have committed the patch.

In v10, it's impossible to have a partition with no partition
constraint, and if it does happen due to some bug, the worst that will
happen is \d will just print nothing, rather than explicitly printing
that there's no constraint.  That's not a serious problem and it
shouldn't happen anyway, so no back-patch.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] UPDATE of partition key
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] Arrays of domains