From: | "Ragnar Garli" <ragnar_garli(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump fail beacuse of oid larger than int32 |
Date: | 2003-01-14 14:37:37 |
Message-ID: | F86B526tr5XsCj1d4vJ00009d66@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all
I have a problem with pg_dump du to oid values larger than signed 32 bit
int.
I run a 7.1.3 on debian potato.
Th database is not big (about 10G) but with a lot of delete and insert.
The thing that crashes it all is when the pg_dump tries to select from
pg_description with a large oid value.
Then the backend in some stage calls dtoi4, wich have a return type of
int32, and this fails.
I think I can modify my 7.1.3 to dump the bases so i can upgrade to 7.3.1,
but I don't know if I will get the same problewm back in a few months.
I dont use the oids on the tables, so i can create the tables on the
7.3.1 with the "without oids" parameter, but will this really save me
from the system oid incrementing.
I did a test on a 7.2.1, creating a table without oids.
I then insertet 10 rows, and the created a new table.
the oid in pg_class had increasedf by twenty some between those two
tables.. why?
so it all comes down to two little questions:
Q1: Is there an easy way to get dump the data from my 7.1.3 ?
Q2: How can I minimalize oid incrementation ?
Regards:
Ragnar Garli
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Dalitz | 2003-01-14 15:11:57 | Re: how to check if a temp table exists? |
Previous Message | Orr, Steve | 2003-01-14 14:16:52 | Re: Server error and deadlocks |