There is a patch in due for release with 6.4 that removes the restriction
that requires all ORDER BY columns be present in the target list.
It does not make sense that a query from the ODBC driver produces an error
in the backend while the same query from the psql does not. The queries
must be different in some way. Is this a passthru query on the ODBC side,
or is it a query generated by a query builder. MS Access for example, will
not necessary show the user the actual query that is rendered to the
backend. To get the actual queries you may need to examine the
psqlodbc.log file.
Jeffrey Lyon wrote:
> Guys,
>
> Thanks for the help, a combination of setting the authentication type to
> ident, telling the ODBC driver to use the 6.2 protocol and some Windows
> registry stuff made the connection work.
>
> But now I'm having another problem - A simple "SELECT * FROM table ORDER
> BY tableid" on the ODBC connection gives me a "The field being ordered
> by must appear in the target list (#1)" error. I've tried creating an
> index on the sorted field with no success. The only way I can run the
> query is unordered. The query, however, runs perfectly under psql!
>
> Any suggestions?