Обсуждение: overflow on numeric ABS(value) >= 10^2

Hi,

i see a bunch of following errors on the logfiles. how
do i figure out which statement causes this error.

2003-05-15 18:59:58 ERROR:  overflow on numeric
ABS(value) >= 10^2 for field with precision 2 scale 0
2003-05-15 18:59:58 WARNING:  ROLLBACK: no transaction
in progress

any help is appreciated.

thanks
Shankar
pgsql 7.3.2/RH 7.3

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

> i see a bunch of following errors on the logfiles. how
> do i figure out which statement causes this error.

yes, you can. Add, log_statement = true in postgresql.conf.

regards,
bhuvaneswaran