Re: [GENERAL] what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE - Mailing list pgsql-odbc

From Richard Broersma
Subject Re: [GENERAL] what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
Date
Msg-id 396486430806110532i23e211d0ta3059e30f927927d@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE  (Richard Huxton <dev@archonet.com>)
List pgsql-odbc
On Wed, Jun 11, 2008 at 12:07 AM, Richard Huxton <dev@archonet.com> wrote:

>> 2008-06-10 15:04:52instrumentation ERROR:  syntax error at or near
>> "SELECT" at character 16
>> 2008-06-10 15:04:52instrumentation STATEMENT:  SELECT INVALID SELECT
>> STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
>> 2008-06-10 15:04:52instrumentation LOG:  statement: ROLLBACK
>
> That appears to be a deliberate bad query issued by something (above the
> odbc layer?). I think you've got something sending "SELECT INVALID SELECT
> STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE" as a query to force a
> rollback. Why it's not just sending "ROLLBACK" I don't know.

I see that makes sense.  At least knowing this will help me to trouble
shoot where to go from here.


--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-odbc by date:

Previous
From: Volkan YAZICI
Date:
Subject: "No Mapping exists" Error
Next
From:
Date:
Subject: wrong value returned?