Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D7AB32E0040 for ; Tue, 13 May 2008 07:07:29 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51312-07 for ; Tue, 13 May 2008 07:07:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by developer.postgresql.org (Postfix) with ESMTP id E08202E003E for ; Tue, 13 May 2008 07:07:26 -0300 (ADT) Received: from feivel (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id D923D214E71; Tue, 13 May 2008 12:07:24 +0200 (CEST) Received: by feivel (Postfix, from userid 1000) id 78577D6D57; Tue, 13 May 2008 12:07:31 +0200 (CEST) Date: Tue, 13 May 2008 12:07:31 +0200 From: Michael Meskes To: List User Cc: pgsql-interfaces@postgresql.org Subject: Re: PG 8.2.7, ECPG & Composite types.. Message-ID: <20080513100731.GA17238@feivel.credativ.de> Mail-Followup-To: List User , pgsql-interfaces@postgresql.org References: <48190AC8.5000005@boscorama.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <48190AC8.5000005@boscorama.com> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/4 X-Sequence-Number: 6728 On Wed, Apr 30, 2008 at 05:11:52PM -0700, List User wrote: > and in ECPG we have tried various things which either end up with a > mismatch between column count & value count; or generate an error > where the values for the embedded composite type have been melded > together as a text string and telling us that the resulting string > is an invalid floating point value. Following is an example of the > latter error: > > exec sql insert into items ( name, price.amt, price.iso, stock ) > values ( 'Test Item', 99.2, 1, 101 ); It says this has an invalid floating point? Could you produce a small test case so we can work on the same example? Also could you enable logging and post the logs? Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!