From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jennifer I Drake/O/VCU <drakeji(at)vcu(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PQputline error with pg_restore |
Date: | 2006-02-09 21:38:32 |
Message-ID: | 4973.1139521112@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jennifer I Drake/O/VCU <drakeji(at)vcu(dot)edu> writes:
> ERROR: copy: line 178286, overflow on numeric ABS(value) >= 10^3 for field with precision 5 scale 3
It would seem that you've got an incorrect (too large) value in a
numeric field in the dumped data.
It's not clear how you got into this state. If you haven't mucked
with the dump then the value was presumably too large in the source
database, which would imply some bug in Postgres that had let it
escape range checking when it was stored into the table originally.
7.3.2 is so far back that this wouldn't surprise me a whole lot.
If you can reproduce such a problem in a more current version, we'd
like to see the details.
The easiest way to fix things is probably to make pg_restore generate
a SQL script file, edit the script, then load it. You can either change
the data value if you think it's wrong, or widen the field precision if
you want to keep the data as-is.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Chandra Sekhar Surapaneni | 2006-02-09 21:44:15 | Re: Update table with data from another table |
Previous Message | Jennifer I Drake/O/VCU | 2006-02-09 21:01:13 | Re: PQputline error with pg_restore |