Re: Tablespace column value null on select * from pg_tables

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Tablespace column value null on select * from pg_tables
Date: 2019-07-28 20:24:39
Message-ID: 20190728202439.GB25242@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)hjp(dot)at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-07-28 20:43:53 Re: Tablespace column value null on select * from pg_tables
Previous Message Peter J. Holzer 2019-07-28 20:21:41 Re: Why does backend send buffer size hardcoded at 8KB?