Postgres Pro
Downloads
Home   >   mailing lists

Re: Tablespace column value null on select * from pg_tables - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Tablespace column value null on select * from pg_tables
Date
Msg-id 20190728202439.GB25242@hjp.at
Whole thread Raw
In response to Re: Tablespace column value null on select * from pg_tables  (Alex Williams <valenceshell@protonmail.com>)
Responses Re: Tablespace column value null on select * from pg_tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Tablespace column value null on select * from pg_tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
On 2019-07-16 19:20:24 +0000, Alex Williams wrote:
> 1. postgres=# ALTER DATABASE mydatabase SET TABLESPACE pg_default;
>
> ERROR:  some relations of database "mydatabase" are already in tablespace "pg_default"
>
> HINT:  You must move them back to the database's default tablespace before using this command.

What's the reason for this error? Wouldn't it be simpler to leave
relations alone which are already in the correct tablespace?

        hp

--
   _  | Peter J. Holzer    | we build much bigger, better disasters now
|_|_) |                    | because we have much more sophisticated
| |   | hjp@hjp.at         | management tools.
__/   | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Why does backend send buffer size hardcoded at 8KB?
Next
From: Tom Lane
Date:
Subject: Re: Tablespace column value null on select * from pg_tables