Re: cant delete row

"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?

            regards, tom lane