more on large oids

Started by Daniel Kalchevover 23 years ago2 messages
#1Daniel Kalchev
daniel@digsys.bg

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Daniel Kalchev (#1)
Re: more on large oids

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