Problem solved, 3GB dumped OK -- Thanks Tom
Steve
Tom Lane wrote:
> steve <[EMAIL PROTECTED]> writes:
> > 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 ra
steve <[EMAIL PROTECTED]> writes:
> 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
> The 3527162388AND is exactly as shown in the log, with no space betwee
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: CommitTr
steve <[EMAIL PROTECTED]> 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
Apologies for posting to [Hackers], have already posted to [Patches]
with no reply.
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: int
