From: Tom Lane <tgl@sss.pgh.pa.us>
To: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
Date: Wed, 01 Dec 2021 11:16:45 -0500
Message-ID: <1734712.1638375405@sss.pgh.pa.us> (raw)
In-Reply-To: <49d925d5-b13a-5952-0be3-fc20b271f22c@jakobs.com>
References: <4011114d-e297-bb2e-ab37-9d1b3880b739@jakobs.com>
<0bd53117207a26a5b8dbe03545448e72397c219f.camel@cybertec.at>
<CAKFQuwbB0JZ63yU7-XwTgOZfmeYXG1pVd+KZkU8uKY3LVpgP2A@mail.gmail.com>
<49d925d5-b13a-5952-0be3-fc20b271f22c@jakobs.com>
Holger Jakobs <holger@jakobs.com> writes:
> Since the default tablespace doesn't have to be mentioned in CREATing an
> object, the information wouldn't be helpful there.
> But when ALTERing an object in order to move it to the default
> tablespace, its name has to be mentioned explicitly. That's where it's
> lacking.
It seems like the core misunderstanding here is closely associated
with the notion that the default tablespace is "unnamed". Every
tablespace has a name. I'm not sure where we might need to clarify
that, but I suspect it's somewhere around the default_tablespace
setting, not ALTER TABLE.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Suggestion: Explain how to move objects to the default tablespace in sql-altertable.html
In-Reply-To: <1734712.1638375405@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox