Thread: more on large oids

more on large oids

From

Daniel Kalchev

Date:

15 April 2002, 05:36:43

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

From

Tom Lane

Date:

15 April 2002, 13:04:52

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