Re: [HACKERS] Documentation improvements for partitioning

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [HACKERS] Documentation improvements for partitioning
Дата
Msg-id 20170215143734.eb2io4k6qmktjbiy@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: [HACKERS] Documentation improvements for partitioning  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: [HACKERS] Documentation improvements for partitioning  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Joshua D. Drake wrote:
> On 02/15/2017 06:10 AM, Simon Riggs wrote:
> > On 13 February 2017 at 05:21, Amit Langote
> > <Langote_Amit_f8@lab.ntt.co.jp> wrote:
> 
> > If I issue DROP TABLE elsewhere, it doesn't refuse to drop because it
> > has indexes, sequences etc on it. So why should it just because it has
> > partitions?
> 
> Because partitions may have data.

So would the table, were it not partitioned.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [HACKERS] Documentation improvements for partitioning
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: [HACKERS] Should we cacheline align PGXACT?