Re: handle tablespaces for partitioned tables during ALTER DATABASE

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: handle tablespaces for partitioned tables during ALTER DATABASE
Дата
Msg-id 20200324192359.yw7q5rlfqqxoktl6@alap3.anarazel.de
обсуждение исходный текст
Ответ на handle tablespaces for partitioned tables during ALTER DATABASE  (postgres@jasonk.me)
Список pgsql-bugs
Дерево обсуждения 
Hi,

On 2020-03-23 23:26:08 -0700, postgres@jasonk.me wrote:
> Normally, you are not allowed to `ALTER DATABASE ... SET TABLESPACE` when the
> target tablespace is in use by a table in the database.  However, this check
> doesn't seem to apply to partitioned tables, and that can lead to unexpected
> behavior.

I don't immediately see what problem this could cause? There's no
physical file associated with a partitioned table, it's "just" a
template for new partitions of that partitioned table.

Greetings,

Andres Freund

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16316: The application has lost the database connection:
Следующее
От: postgres@jasonk.me
Дата:
Сообщение: Fwd: Re: handle tablespaces for partitioned tables during ALTERDATABASE