Re: pg_largeobject and oid mistmach after restore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_largeobject and oid mistmach after restore
Дата
Msg-id 14440.1075147397@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_largeobject and oid mistmach after restore  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
Ответы Re: pg_largeobject and oid mistmach after restore  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
Список pgsql-general
Jeremiah Jahn <jeremiah@cs.earlham.edu> writes:
> when I run the following two commands all of my OIDs for my blobs (about
> 5.5 million of them) no longer reference anything in pg_largeobject.
> All of the loid values change.

pg_dump/pg_restore do not (and cannot) arrange for large objects to have
the same OIDs after restore as they had before.  What they do try to do
is update references to the large objects to have the new OID values.
Last I checked, they look in columns of types "oid" and "lo" (if "lo"
exists) for such references.  Maybe you were engaging in some type
punning, like storing your references in int4 or int8 columns?

            regards, tom lane

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

Предыдущее
От: Martín Marqués
Дата:
Сообщение: Re: Where is initdb?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: OT: SCO Extortion