| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2010-09-03 21:53:09 | Re: Problem with simple SELECT over ODBC |
| Previous Message | Werner Kuhnle | 2010-09-03 14:52:26 | Re-2: Problem with simple SELECT over ODBC |