From: Byron Nikolaidis <byronn@insightdist.com>
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
Date: Mon, 27 Jul 1998 09:36:52 -0400
Message-ID: <35BC8274.C329C0@insightdist.com> (raw)
References: <01BDB987.F8FA2AF0@wynyard.alphanet.net.au>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, michaely@alphanet.net.au
Subject: Re: [INTERFACES] Problem of using Access '97 to open db
In-Reply-To: <35BC8274.C329C0@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox