Re: Tablespace column value null on select * from pg_tables

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: Tablespace column value null on select * from pg_tables
Дата
Msg-id 20190728202439.GB25242@hjp.at
обсуждение исходный текст
Ответ на Re: Tablespace column value null on select * from pg_tables  (Alex Williams <valenceshell@protonmail.com>)
Ответы 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>)
Список 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@hjp.at         | management tools.
__/   | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Why does backend send buffer size hardcoded at 8KB?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Tablespace column value null on select * from pg_tables