"Oliver Elphick" <olly@lfix.co.uk> writes:
> Tom Lane wrote:
>>>> "Tamsin" <tg_mail@bryncadfan.co.uk> writes:
> test=# delete from order_head where order_head_id = 1581;
> ERROR: overflow on numeric ABS(value) >= 10^9 for field with precision 8
> scale 2
>>>>
>>>> This is extremely bizarre. A DELETE does not care what data is in the
>>>> row. Do you perhaps have rules or triggers on this table that you
>>>> haven't told us about?
> But surely the WHERE clause on this DELETE will care? I don't know
> how the internal details are arranged, but it sounds as though it is
> the comparison that is blowing up.
No, because the WHERE's comparison is on an integer field. Besides,
that message comes out when trying to store a numeric value into a
column, not when fetching or doing arithmetic on one.
regards, tom lane