From: | steve <steve(at)jlajla(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_dump oid problems |
Date: | 2001-10-11 07:49:06 |
Message-ID: | 3BC54EF2.B1341A4F@jlajla.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom,
Thanks for the prompt reply. Following is the postgresql log output:
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: SELECT Oid FROM pg_index i WHERE i.indisprimary AND
i.indrelid = '3527162388'::oid
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: SELECT c.relname FROM pg_index i LEFT OUTER JOIN pg_class c
ON c.oid = i.indexrelid WHERE i.indrelid = 3527162388AND i.indisprimary
ERROR: dtoi4: integer out of range
DEBUG: AbortCurrentTransaction
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
The 3527162388AND is exactly as shown in the log, with no space between the
value and the AND, I guess this is the problem, wherever it's being
generated in the code.
HTH
Thanks,
Steve
Tom Lane wrote:
> steve <steve(at)jlajla(dot)com> writes:
> > When trying to pg_dump on 7.1.2 (& 7.1.3) I get the following error
> > message:
>
> > bash-2.04$ pg_dump dwh
> > getTables(): SELECT (for PRIMARY KEY NAME) failed for table nlcdmp.
> > Explanation from backend: ERROR: dtoi4: integer out of range
>
> > Several of my tables have very large OIDs (over 4 billion in some cases
>
> Hmm. Okay, I think I can see how over-2-gig OIDs might lead to that
> error message, but that doesn't really help in tracking down the specific
> location of the problem. Could you run pg_dump after doing
> export PGOPTIONS="-d2"
> so that its queries get sent to the postmaster log? Then looking at the
> log to see the last couple of queries before the failure should tell us.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Kindness | 2001-10-11 08:27:44 | Btree index ignored on SELECT until VACUUM ANALYZE |
Previous Message | Thomas Lockhart | 2001-10-11 06:46:12 | Re: EXTRACT broken |