From: David Hartwig <daveh@insightdist.com>
To: Sferacarta Software <sferac@bo.nettuno.it>
To: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [HACKERS] Access & Postgres
Date: Wed, 08 Jul 1998 12:01:01 -0400
Message-ID: <35A397BC.227963C7@insightdist.com> (raw)
References: <35A133DB.CFE63868@insightdist.com>
<17439.980708@bo.nettuno.it>
The backend patch is downloadable text file, linked to our FAQ. I think the direct URL is
http://www.insightdist.com/psqlodbc/junkfilter_patch.txt
I know the code works. Let me know, though, if you have trouble retrieving or applying it. The
patch was originally 2 patches. I just cat'ed them together. It should apply properly.
PS: This is the first time I have distributed the patch this way. So could I get an affirmation from
you even if it goes smoothy.
Sferacarta Software wrote:
> Hello David,
>
> Do you remember our problem with ORDER BY not in target list ?
> Well, seems that now we can't go on without your fix.
> Please may you send me it ? Thanks
>
> lunedì, 6 luglio 98, you wrote:
>
> DH> This question may be better posted on the interfaces list.
> DH> See: http://www.insightdist.com/psqlodbc
> DH> Visit the FAQ. It is one of the last items listed.
> H> Sferacarta Software wrote:
>
> >> Hi all,
> >> I have this problem:
> >>
> >> This sample query create with Access
> >>
> >> SELECT figure.*, utenti.ragione_sociale
> >> FROM figure INNER JOIN utenti ON figure.codice_figura = utenti.azienda;
> >>
> >> via-psqlODBC reports this
> >>
> >> ERROR: The field being ordered by must appear in the target list'
> >> STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
> >>
> >> Postgres executes this sql query (I find this in Psqlodbc.log file) :
> >>
> >> SELECT figure.oid,utenti.azienda
> >> FROM utenti,figure WHERE (figure.codice_figura = utenti.azienda ) ORDER BY figure.codice_figura
> >>
> >> Why is there ORDER BY CLAUSE ?
> >> Why is there only "figure.oid" instead of "figure.*" in SELECT
> >> arguments ??????
> >>
> >> Best regards,
> >> Marco Pollachini
> >> Sferacarta mailto:sferac@bo.nettuno.it
>
> Best regards,
> Jose' mailto:sferac@bo.nettuno.it
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, sferac@bo.nettuno.it
Subject: Re: [HACKERS] Access & Postgres
In-Reply-To: <35A397BC.227963C7@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