Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.9.1/8.9.1) with ESMTP id LAA11124 for ; Fri, 8 Jan 1999 11:11:24 -0500 (EST) (envelope-from byronn@insightdist.com) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id KAA06158 for pgsql-interfaces@hub.org; Fri, 8 Jan 1999 10:48:52 -0500 (EST) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA35837; Fri, 8 Jan 1999 10:30:24 -0500 Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03) id AA79296; Fri, 8 Jan 1999 10:25:03 -0500 Message-Id: <3696251B.CAC64C1A@insightdist.com> Date: Fri, 08 Jan 1999 10:32:43 -0500 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: bill@hammondgroves.com Cc: "pgsql-interfaces@hub.org" , "Ken J. Wright" , "Thomas G. Lockhart" Subject: Re: Money type mapping to backend References: <199901081135.GAB79140@osage.gate.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bill Hutto wrote: > > Please send the "psqlodbc.log" file of the session. This will show the sql statement > > as sent to the backend and prove once and for all what the error is. It is hard to > > make a diagnosis without knowing what really is going wrong. > > OK Byron, I've attached the session using data bound controls from > Visual Basic. > > Table Name: visdata > > Fields: > field1 char(40) > amount money > quantity int8 > > If you need any other info, just let me know. > > Hey, guess what, I was testing the whole time under Postgres 6.3 and it does not require the quotes around money type! Only postgres 6.4 requires the quotes! That seems kind of weird. Anyone got any comments? In the meantime, do you have a 6.3 database laying around to try? Byron