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
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>
Comments: In-reply-to Holger Jakobs <holger@jakobs.com>
	message dated "Wed, 01 Dec 2021 16:49:44 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1734711.1638375405.1@sss.pgh.pa.us>
Date: Wed, 01 Dec 2021 11:16:45 -0500
Message-ID: <1734712.1638375405@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1734712.1638375405%40sss.pgh.pa.us>
Precedence: bulk

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