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