Message-Id: <35BC8274.C329C0@insightdist.com>
Date: Mon, 27 Jul 1998 09:36:52 -0400
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: Michael Yeung <michaely@alphanet.net.au>
Cc: "'Interfaces of Postgres'" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Problem  of using Access '97 to open db
References: <01BDB987.F8FA2AF0@wynyard.alphanet.net.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Michael Yeung wrote:
> 
> hi all,
> 
> I have linked the postgresql dB through ODBC Drivers from www.insightdist.com   !
> 
> Then i use Access 97 to open the database and the error says
> 
> 'Error while executing query; WARN :parser : parse error at or near """ '
> 
> I checked the log and discover that the SELECT statement with double quote around the table name and the field name. How does it fixed with this ?
> 


Postgres (at least 6.3.2) supports double quotes around identifiers. 
This allows for embedded spaces and other characters to be used in table
names and field names.  Therefore, at least under 6.3.2, something like
select "test1"."a" from "test1" is perfectly legal.  

For ODBC, the driver now returns " as the identifier quote character. 
Access then uses this character for identifiers.

Are you using an earlier version of Postgres that perhaps didn't support
quotes?  

If 6.2 postgres doesn't support quotes, I could easily patch the driver
to not use quotes when using 6.2 protocol.

Please let me know.

Byron