Re-2: Problem with simple SELECT over ODBC

Hi Tom,

thanks for your reply.

the log contains :
"
2010-09-03 13:40:04 CEST FEHLER: Syntaxfehler bei =BB,=AB bei Zeichen 1
2010-09-03 13:40:04 CEST ANWEISUNG: , "ctid" SELECT Kurzzeichen,Name_Feld,E=
URO_Umr_Faktor,NKStellen,Ro wTimestamp,RowUserID,RowDDMFields,RowID FROM Wa=
ehrungen ORDER BY Kurzzeichen
"
but I don't know what the ', "ctid" ' means and why it is in the log; my sq=
l quere does not contain this; it definitely begins with "SELECT"

Regards

Werner


To: tgl@sss.pgh.pa.us
Cc: pgsql-odbc@postgresql.org



--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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

"Werner Kuhnle" 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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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

Hi Werner,

(2010/09/04 23:18), Werner Kuhnle wrote:
> Hi Hiroshi,
>
>>
>> Could you send me directly the Mylog output?
>>
> What do you mean with "Mylog output" ?
> The log entries in pg_log\postgresql*.log are:
> "
> 2010-09-03 13:40:04 CEST FEHLER: Syntaxfehler bei =BB,=AB bei Zeichen =
1
> 2010-09-03 13:40:04 CEST ANWEISUNG: , "ctid" SELECT Kurzzeichen,Name_F=
eld,EURO_Umr_Faktor,NKStellen,RowTimestamp,RowUserID,RowDDMF ields,RowID F=
ROM Waehrungen ORDER BY Kurzzeichen
> "
> but I don't know what the ', "ctid" ' means and why it is in the log; m=
y sql query does not contain this; it definitely begins with "SELECT"

OK could you please try the drivers on testing for 8.4.0202 at
http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?

regards,
Hiroshi Inoue

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc