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 = 2500000000;
ERROR: dtoi4: integer out of range
A short-term workaround is to hack pg_dump so that it explicitly coerces
the literal to OID and/or quotes the literal:
regression=# select * from pg_description where objoid = 2500000000::oid;
objoid | classoid | objsubid | description
--------+----------+----------+-------------
(0 rows)
regression=# select * from pg_description where objoid = '2500000000';
objoid | classoid | objsubid | description
--------+----------+----------+-------------
(0 rows)
This is done in many places in pg_dump, but not in DumpComment which is
relatively new code :-(
A longer-term question is how to persuade the parser to get this right
without such help. I think that this is another variant of the
perennial numeric-precision issue and will not be real easy to fix.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
