Received: from flex.flex.ro (IDENT:root@[193.230.187.164]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA24848 for ; Mon, 1 Mar 1999 11:21:24 -0500 (EST) (envelope-from teo@flex.ro) Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.9.1/8.9.1) with ESMTP id SAA03936; Mon, 1 Mar 1999 18:19:46 +0200 Sender: teo@flex.flex.ro Message-ID: <36DABEF1.7DDEB946@flex.ro> Date: Mon, 01 Mar 1999 18:23:13 +0200 From: Constantin Teodorescu Organization: FLEX Consulting X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.2.2 i586) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane , PostgreSQL Interfaces , Ben Gunter Subject: Re: [INTERFACES] Tables acting funny with pgaccess References: <14012.920299248@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tom Lane wrote: > > At a guess, pgaccess is generating the table with case of field names > preserved? Ordinarily, table and field names are implicitly downcased, > but not if you put double quotes around 'em. A very good guess I could say ! :-) I have fixed that bug so we have a PgAccess 0.95 version ! The bug was also present in sort field specification and in filter field specification. I have tested with several examples, including field names with mixed case letters and also having spaces inside field names. It worked. Please get the latest 0.95 version from http://www.flex.ro/pgaccess or ftp://ftp.flex.ro/pub/pgaccess/pgaccess-0.95.tar.gz and let me know if it's working as you expected. Thanks for your help improving PgAccess, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA