Re: pg_migrator to /contrib in a later 9.0 beta

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_migrator to /contrib in a later 9.0 beta
Дата
Msg-id 17931.1273160966@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_migrator to /contrib in a later 9.0 beta  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: pg_migrator to /contrib in a later 9.0 beta  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Excerpts from Bruce Momjian's message of jue may 06 11:19:27 -0400 2010:
>> It seems copying over pg_statistic would require preservation of
>> pg_class.oid.  Right now we only preserve pg_class.relfilenode.

> That could be fixed easily by creating a throwaway table which included the
> qualified table name instead of the OID, and reloading it into pg_statistic
> after the migration.

Yeah.  Casting to and from regclass would do the trick too.
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Adding xpath_exists function
Следующее
От: Florian Pflug
Дата:
Сообщение: Re: Partitioning/inherited tables vs FKs