Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Access & Postgres

From: David Hartwig <daveh(at)insightdist(dot)com>
To: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>, pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Access & Postgres
Date: 1998-07-06 20:30:19
Message-ID: 35A133DB.CFE63868@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
This question may be better posted on the interfaces list.

See:  http://www.insightdist.com/psqlodbc
Visit the FAQ.   It is one of the last items listed.

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(at)bo(dot)nettuno(dot)it




In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 1998-07-06 22:18:49
Subject: Which signal to use for CANCEL from postmaster to backend?
Previous:From: Tom LaneDate: 1998-07-06 20:02:25
Subject: New s_lock.h fails on HPUX with gcc

pgsql-interfaces by date

Next:From: Bruce TaylorDate: 1998-07-07 06:53:08
Subject: A fast, cheap database-backed Web server
Previous:From: Elaine ArajoDate: 1998-07-06 20:10:06
Subject: PostgreSql-users and passwords

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group