Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 58E152E0047 for ; Wed, 11 Jun 2008 09:32:52 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26481-05 for ; Wed, 11 Jun 2008 09:32:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.237]) by developer.postgresql.org (Postfix) with ESMTP id 4E40A2E0043 for ; Wed, 11 Jun 2008 09:32:47 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so3712439rvf.43 for ; Wed, 11 Jun 2008 05:32:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=F8C/NrTIygw1UEGdpy/3BFxiMKU4oHb8ebXj3fE6O3w=; b=jaCKL4D8RXMtPvmFkoQUVK5MfWDe0U2a1VR8+edl/kEhqxyaHlZ4Smjem6kj13XLDe kWLhFpw0sH3WAC5w2z9lWhSKHAi6/6fSywws7nUhV10SKTk4yWM87LfBv5Bn4/WYpI9l 8x8/URdZQdfN5l3Nyp8bw1b53n1DTxjBnv4fg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=eEeLJMgCjEduxoO+JsRCAyM/m5y5PawtfeINa9LWg3MZkhEv4L0Rg84jL+Ku1gEoLt 0GLuJAaQQtDdnrcP5AChj+++RDvucBO0NM5gQlaKxGj9tGD0zDVJjQ1HFrRwo6TIETnF wKR+sdRbZqtAwehKX+6YoG4GcezErF8T9KoQ8= Received: by 10.141.62.15 with SMTP id p15mr3780270rvk.144.1213187565764; Wed, 11 Jun 2008 05:32:45 -0700 (PDT) Received: by 10.140.165.8 with HTTP; Wed, 11 Jun 2008 05:32:45 -0700 (PDT) Message-ID: <396486430806110532i23e211d0ta3059e30f927927d@mail.gmail.com> Date: Wed, 11 Jun 2008 05:32:45 -0700 From: "Richard Broersma" To: "Richard Huxton" Subject: Re: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE Cc: "PostgreSQL - General ML" , pgsql-odbc@postgresql.org In-Reply-To: <484F79B0.5060401@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <396486430806102106i4915845ag746566c333bdc684@mail.gmail.com> <484F79B0.5060401@archonet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/344 X-Sequence-Number: 133873 On Wed, Jun 11, 2008 at 12:07 AM, Richard Huxton 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