Re: cant delete row

"Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:
> Tom Lane wrote:
>>>> "Tamsin" <tg_mail(at)bryncadfan(dot)co(dot)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