From: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
---|---|
To: | Michael Yeung <michaely(at)alphanet(dot)net(dot)au> |
Cc: | "'Interfaces of Postgres'" <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] Problem of using Access '97 to open db |
Date: | 1998-07-27 13:36:52 |
Message-ID: | 35BC8274.C329C0@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Byron Nikolaidis | 1998-07-27 14:30:02 | Old ODBC Driver references on website |
Previous Message | Peter T Mount | 1998-07-27 13:28:28 | Re: [INTERFACES] large objects |