pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: David Hartwig <daveh@insightdist.com>
To: Jeffrey Lyon <lyonj@em-systems.com>
Cc: byronn@insightdist.com, pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: PostgreSQL/ODBC/WinNT
Date: Mon, 15 Jun 1998 15:49:23 -0400
Message-ID: <35857AC3.419D17D7@insightdist.com> (raw)
References: <35855FB1.72E132C4@em-systems.com>

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?






Message-ID: <35857AC3.419D17D7@insightdist.com>
Permalink:  ../35857AC3.419D17D7@insightdist.com/
Also on:    postgresql.org/message-id/35857AC3.419D17D7@insightdist.com

 · 

reply
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: daveh@insightdist.com, lyonj@em-systems.com
  Subject: Re: PostgreSQL/ODBC/WinNT
  In-Reply-To: <35857AC3.419D17D7@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