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@xxxxxx | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
Attachment:
signature.asc
Description: PGP signature
