Обсуждение: more on large oids

Поиск
Список
Период
Сортировка

more on large oids

От
Daniel Kalchev
Дата:
I have hit another very annouing problem with the oids being larger than 
max_int. When tables are created under such circumstances, pg_dump cannot dump 
the database anymore. The error is

getTables(): SELECT (for PRIMARY KEY) failed on table config_2002_03_02.  
Explanation from backend: ERROR:  dtoi4: integer out of range

Any idea how to fix this? This is on 7.1.3. Will the 7.2 pg_dump handle this 
database?

Daniel

Re: more on large oids

От
Tom Lane
Дата:
Daniel Kalchev <daniel@digsys.bg> writes:
> getTables(): SELECT (for PRIMARY KEY) failed on table config_2002_03_02.  
> Explanation from backend: ERROR:  dtoi4: integer out of range

> Any idea how to fix this? This is on 7.1.3. Will the 7.2 pg_dump handle this 
> database?

Yes.
        regards, tom lane