Re: BUG #5184: default tablespace owner is not dumped

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5184: default tablespace owner is not dumped
Дата
Msg-id 25166.1258092812@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5184: default tablespace owner is not dumped  ("Robert Haas" <robertmhaas@gmail.com>)
Ответы Re: BUG #5184: default tablespace owner is not dumped  (Robert Haas <robertmhaas@gmail.com>)
Re: BUG #5184: default tablespace owner is not dumped  (Pedro Gimeno <pgsql-003@personal.formauri.es>)
Список pgsql-bugs
"Robert Haas" <robertmhaas@gmail.com> writes:
> The following command does not change the output of "pg_dumpall":
> alter tablespace pg_default owner to bob;

I don't think this is a bug.  It's one specific aspect of a general
principle that system objects don't get dumped.  If they did, using
pg_dump to upgrade across major versions would be somewhere between
impossible and your worst nightmare.

It might be nice if manual changes to system objects got dumped,
but that's really an AI-complete problem --- which properties of
the objects represent manual changes, and how can we know whether
trying to apply those changes to a new system version will work?

            regards, tom lane

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

Предыдущее
От: "Robert Haas"
Дата:
Сообщение: BUG #5184: default tablespace owner is not dumped
Следующее
От: "Siwat Siwarborvorn"
Дата:
Сообщение: BUG #5185: postgres error "invalid page header in block xx of relation "pg_proc_proname_args_nsp_index"