Re: [HACKERS] Why "ERROR: dtoi4: integer out of range" on pg_dump

2001-09-07 Thread Tom Lane
Martin Weinberg <[EMAIL PROTECTED]> writes: > Thanks, Tom! This was the problem. Here is my patch to pg_dump.c > that appears to fix the problem. Turns out that the oid needed to > be coerced in two places. I've already committed fixes (I found one or two more places that were missing the same

Re: [HACKERS] Why "ERROR: dtoi4: integer out of range" on pg_dump

2001-09-07 Thread Martin Weinberg
Thanks, Tom! This was the problem. Here is my patch to pg_dump.c that appears to fix the problem. Turns out that the oid needed to be coerced in two places. --- --- pg_dump.c Thu Sep 6 21:18:21 2001 +++ pg_dump.c.ori

Re: [HACKERS] Why "ERROR: dtoi4: integer out of range" on pg_dump

2001-09-03 Thread Tom Lane
Martin Weinberg <[EMAIL PROTECTED]> writes: > DumpComment: SELECT failed: 'ERROR: dtoi4: integer out of range Hmm. I can reproduce this error message if I suppose that you have OIDs exceeding 2 billion. pg_dump will produce queries like: regression=# select * from pg_description where objoid

[HACKERS] Why "ERROR: dtoi4: integer out of range" on pg_dump

2001-08-31 Thread Martin Weinberg
Folks, We have a database with several very large tables. When trying to pg_dump we get the above error, e.g.: pg_dump -v wsdb -- saving database definition -- last builtin oid is 18539 -- reading user-defined types -- reading user-defined functions -- reading user-defined aggregates -