From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | integer out of range errors |
Date: | 2002-07-16 16:30:55 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB04C73CD0@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy:
Running PostgreSQL 7.1.3 on RedHat Linux 7.2 kernel 2.4.7-10.
We are having some problems trying to figure out what is causing
the following errors (and, if they are effecting something else).
When I do a pg_dump, I get the following:
[snip error]
getTables(): SELECT (for PRIMARY KEY) failed on table t_prof_er_full_detail.
Explanation from backend: ERROR: dtoi4: integer out of range
[/snip error]
I've read around and a few articles in the google newsgroup says to
get pg_dump 7.2 (which suppose to dump for PostgreSQL 7.1 as well)
and if that is so, then:
a) where do I find pg_dump 7.2 (as a source code or a binary somewhere?)
b) how does this effect other things like pgAdmin II (where I get a similar
error regarding a key (if it's related at all! *shrug*)
c) does OID max out at 2 billion before i start to get errors?
Not sure about a lot of this (as I'm still learning = breaking things).
Any suggestions would be appreciated.
Thanks!
-X
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Birch | 2002-07-16 16:31:51 | timestamped archive data index searches |
Previous Message | Neil Conway | 2002-07-16 16:25:06 | Re: COPY seems to work, but no data in the table |