X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 87DC3D1F406
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 22:23:46 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 37098-06
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 19:22:23 -0300 (ADT)
Received: from mail.osdl.org (fw.osdl.org [65.172.181.6])
	by svr1.postgresql.org (Postfix) with ESMTP id 231A7D1F405
	for <pgsql-interfaces@postgresql.org>;
	Thu,  7 Aug 2003 19:23:35 -0300 (ADT)
Received: from osdl.org (markw@ibm-b.pdx.osdl.net [172.20.1.51])
	by mail.osdl.org (8.11.6/8.11.6) with ESMTP id h77MNQo24759;
	Thu, 7 Aug 2003 15:23:27 -0700
Message-Id: <200308072223.h77MNQo24759@mail.osdl.org>
Date: Thu, 7 Aug 2003 15:23:23 -0700 (PDT)
From: markw@osdl.org
Subject: Re: libpq ERROR: overflow on numeric ABS(value) ... 
To: tgl@sss.pgh.pa.us
Cc: pgsql-interfaces@postgresql.org,
	osdldbt-general@lists.sourceforge.net
In-Reply-To: <9052.1060294488@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: TEXT/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/35
X-Sequence-Number: 4389

On  7 Aug, Tom Lane wrote:
> markw@osdl.org writes:
>>>> DECLARE mycursor CURSOR FOR SELECT new_order(...)
>>>> FETCH ALL IN mycursor
>>>> ERROR:  overflow on numeric ABS(value) >= 10^4 for field with precision 4 scale 0
> 
>> Does it make sense that is throws the error on the FETCH instead of the
>> previous statement?
> 
> Sure: the cursor won't actually be executed until you fetch from it.

Oh right, I should have remembered that...

Thanks,
Mark