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

Re: Re-2: Problem with simple SELECT over ODBC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Werner Kuhnle" <wek(at)kuhnle(dot)com>
Cc: pgsql-odbc(at)postgreSQL(dot)org
Subject: Re: Re-2: Problem with simple SELECT over ODBC
Date: 2010-09-03 15:23:53
Message-ID: 23328.1283527433@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
"Werner Kuhnle" <wek(at)kuhnle(dot)com> writes:
> the log contains :
> "
> 2010-09-03 13:40:04 CEST FEHLER: Syntaxfehler bei , bei Zeichen 1
> 2010-09-03 13:40:04 CEST ANWEISUNG: , "ctid" SELECT Kurzzeichen,Name_Feld,EURO_Umr_Faktor,NKStellen,Ro wTimestamp,RowUserID,RowDDMFields,RowID FROM Waehrungen ORDER BY Kurzzeichen
> "
> but I don't know what the ', "ctid" ' means and why it is in the log; my sql quere does not contain this; it definitely begins with "SELECT"

Ah-hah.  The ODBC driver is inserting that because it would like to see
the ctid system column in the result.  It's evidently getting confused
and inserting it in the wrong place.  Anybody on the list recognize this
misbehavior?

			regards, tom lane

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2010-09-03 21:53:09
Subject: Re: Problem with simple SELECT over ODBC
Previous:From: Werner KuhnleDate: 2010-09-03 14:52:26
Subject: Re-2: Problem with simple SELECT over ODBC

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