MS Access via ODBC - Mailing list pgsql-sql

From Taral
Subject MS Access via ODBC
Date
Msg-id 000001bdc3c6$299f7960$3b291f0a@taral
Whole thread Raw
List pgsql-sql
I noticed that when trying to get MS Access to do a query of "SELECT * FROM
table ORDER BY somekey" as its data source for a form, it actually issues
"SELECT primarykey FROM table ORDER BY somekey", which PostgreSQL rejects
because "somekey" isn't being selected.

Now, either PostgreSQL has put an (odd) restriction on SQL, or MS Access is
issuing an invalid SQL query. Which one is it?

Taral


pgsql-sql by date:

Previous
From: Johann Spies
Date:
Subject: Re: [SQL] What is the recommended machine configuration?
Next
From: "Stuart logan"
Date:
Subject: Installing PostgreSQL 6.3.2 On Linux