Re: cant delete row - Mailing list pgsql-general

From Tom Lane
Subject Re: cant delete row
Date
Msg-id 16609.986481172@sss.pgh.pa.us
Whole thread Raw
In response to cant delete row  ("Tamsin" <tg_mail@bryncadfan.co.uk>)
Responses Re: cant delete row
RE: cant delete row
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Paul A. Lender"
Date:
Subject: Data transfer format between UNIX server and Windows client?
Next
From: Uros Gruber
Date:
Subject: Trouble with JOINS