Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2811: Error determining param type in prepared statement of unused variable - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2811: Error determining param type in prepared statement of unused variable
Date
Msg-id 3364.1165445732@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2811: Error determining param type in prepared statement of unused variable  ("Ross Cohen" <rcohen@snurgle.org>)
Responses Re: BUG #2811: Error determining param type in prepared statement of unused variable
List pgsql-bugs
Tree view 
"Ross Cohen" <rcohen@snurgle.org> writes:
> PREPARE demo (unknown) AS SELECT 1;
> ERROR:  could not determine data type of parameter $1

This doesn't seem like a bug to me.  The parser needs to be able to
resolve the types of any unknown parameters, and you've not given it
enough information to do that.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #2812: Transaction is aborted after error
Next
From: Christopher Browne
Date:
Subject: Re: BUG #2810: restore to lower version of dump