doh! now i feel _really_ stupid!
of course, I managed to forget all about the rule i made which inserts into
another table when a row is deleted. altered that table & recreated the
rule, and all is fine.
thanks tom!
tamsin
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: 05 April 2001 15:33
> To: Tamsin
> Cc: Postgres General
> Subject: Re: [GENERAL] 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>