BUG #2811: Error determining param type in prepared statement of unused variable

From: "Ross Cohen" <rcohen(at)snurgle(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2811: Error determining param type in prepared statement of unused variable
Date: 2006-12-06 18:02:43
Message-ID: 200612061802.kB6I2hIf073485@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2811
Logged by: Ross Cohen
Email address: rcohen(at)snurgle(dot)org
PostgreSQL version: 8.2
Operating system: linux (fedora core 4, released RPMS)
Description: Error determining param type in prepared statement of
unused variable
Details:

Got this error:
ERROR: could not determine data type of parameter $1

However, $1 is never used in the query so this shouldn't be a problem. The
following query demonstrates the problem.

PREPARE demo (unknown) AS SELECT 1;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2006-12-06 19:37:32 8.2 bug with outer join reordering
Previous Message Murali 2006-12-06 09:21:48 BUG #2810: restore to lower version of dump