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

Re: BUG #5805: "not determine data type" for params in comments

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Maxim Turchin <nehxby(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5805: "not determine data type" for params in comments
Date: 2010-12-31 12:43:51
Message-ID: AANLkTi=J5LNvXtpMUDuJMr5iRjQWHjh=AwQdaR1fAaOA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Dec 29, 2010 at 11:00 AM, Maxim Turchin <nehxby(at)gmail(dot)com> wrote:
> 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;

You could fix this either by having your driver specify a type for the
parameter, or by changing the query to select $1::text rather than
just $1.  I'm not exactly sure how to do either of those things on the
PHP side, but there's probably a way...

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

pgsql-bugs by date

Next:From: mahmoud elzaiadyDate: 2011-01-02 11:40:07
Subject: BUG #5809: bigserial duplicate value
Previous:From: d.yadagiriDate: 2010-12-31 10:25:45
Subject: unable to export database from postgres

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