Re: pg_dump oid problems

Problem solved, 3GB dumped OK -- Thanks Tom

Steve

Tom Lane wrote:

> steve <steve@jlajla.com> 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 between the
> > value and the AND, I guess this is the problem, wherever it's being
> > generated in the code.
>
> That's evidently coming from line 2346 of src/bin/pg_dump/pg_dump.c:
>
>                               "WHERE i.indrelid = %s"
>
> Try changing it to
>
>                               "WHERE i.indrelid = '%s'::oid "
>
> (Problem seems to be solved already in 7.2devel)
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)