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

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

From: Richard Huxton <dev(at)archonet(dot)com>
To: Richard Broersma <richard(dot)broersma(at)gmail(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 07:07:28
Message-ID: 484F79B0.5060401@archonet.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-odbc
Richard Broersma wrote:
> Server logs below.  Notice how an error raised in a connection to the
> proj02u20411 database forces the transaction in the instrumentation
> database to rollback.
> Can anyone explain why connections that as far as PG should conserned
> are unrelated are actually interferring with one another?

I don't see any errors on proj...

> --------------------------------------------------------------------------------
[snip]
> 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.

-- 
   Richard Huxton
   Archonet Ltd

In response to

Responses

pgsql-odbc by date

Next:From: Volkan YAZICIDate: 2008-06-11 08:21:46
Subject: "No Mapping exists" Error
Previous:From: Richard BroersmaDate: 2008-06-11 04:06:13
Subject: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE

pgsql-admin by date

Next:From: Devendra Singh RawatDate: 2008-06-11 07:42:45
Subject: Re: Disk Space issue
Previous:From: Praveen Kumar (TUV)Date: 2008-06-11 06:14:44
Subject: Re: Disk Space issue

pgsql-general by date

Next:From: Magnus HaganderDate: 2008-06-11 08:14:40
Subject: Re: [ANNOUNCE] PostgreSQL Software Catalogue
Previous:From: Richard HuxtonDate: 2008-06-11 07:03:34
Subject: Re: encoding confusion

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