Postgres Pro
Downloads
Home   >   mailing lists

Re: handle tablespaces for partitioned tables during ALTER DATABASE - Mailing list pgsql-bugs

From Andres Freund
Subject Re: handle tablespaces for partitioned tables during ALTER DATABASE
Date
Msg-id 20200324192359.yw7q5rlfqqxoktl6@alap3.anarazel.de
Whole thread Raw
In response to handle tablespaces for partitioned tables during ALTER DATABASE  (postgres@jasonk.me)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16316: The application has lost the database connection:
Next
From: postgres@jasonk.me
Date:
Subject: Fwd: Re: handle tablespaces for partitioned tables during ALTERDATABASE