Re: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: "PostgreSQL - General ML" <pgsql-general(at)postgresql(dot)org>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
Date: 2008-06-11 12:32:45
Message-ID: 396486430806110532i23e211d0ta3059e30f927927d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-odbc

On Wed, Jun 11, 2008 at 12:07 AM, Richard Huxton <dev(at)archonet(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-06-11 13:36:46 Re: Cannot Drop Schema
Previous Message Tommy Gildseth 2008-06-11 08:57:38 Re: Disk Space issue

Browse pgsql-general by date

  From Date Subject
Next Message Selena Deckelmann 2008-06-11 14:15:59 Call for proposals: PDXPUG PgDay at OSCON - proposals due FRIDAY!
Previous Message Mattias.Arbin 2008-06-11 10:30:39 Re: Insert into master table ->" 0 rows affected" -> Hibernate problems

Browse pgsql-odbc by date

  From Date Subject
Next Message mike.gagnon 2008-06-11 14:04:22 wrong value returned?
Previous Message Volkan YAZICI 2008-06-11 08:21:46 "No Mapping exists" Error