From: | "Maxim Turchin" <nehxby(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5805: "not determine data type" for params in comments |
Date: | 2010-12-29 16:00:59 |
Message-ID: | 201012291600.oBTG0xcP053988@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: 5805
Logged by: Maxim Turchin
Email address: nehxby(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system: Ubuntu Linux
Description: "not determine data type" for params in comments
Details:
I use php PDO extention. If in prepared statement exists comments with
string like ":somestring", this string is parameter, and need to fill.
Example SQL:
select
/* :some_old_param, */
:someparam1,
:someparam2
from sometable;
When i fill last 2 param, and not fill first old param (in comment!), i get
error "not determine data type of parameter $1".
postgresql log:
2010-12-29 17:43:10 EET ERROR: could not determine data type of parameter
$1
2010-12-29 17:43:10 EET STATEMENT: select
/* $1, */
$2,
$3
from sometable;
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Davis | 2010-12-29 16:06:07 | Re: BUG #5804: Connection aborted after many queries. |
Previous Message | Kevin Grittner | 2010-12-29 15:58:38 | Re: BUG #5804: Connection aborted after many queries. |