"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?
regards, tom lane