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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-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

pgsql-odbc by date

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

pgsql-admin by date

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

pgsql-general by date

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

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