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

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: BUG #5805: "not determine data type" for params in comments
Дата
Msg-id AANLkTi=J5LNvXtpMUDuJMr5iRjQWHjh=AwQdaR1fAaOA@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #5805: "not determine data type" for params in comments  ("Maxim Turchin" <nehxby@gmail.com>)
Список pgsql-bugs
On Wed, Dec 29, 2010 at 11:00 AM, Maxim Turchin <nehxby@gmail.com> wrote:
> 2010-12-29 17:43:10 EET ERROR: =A0could not determine data type of parame=
ter
> $1
> 2010-12-29 17:43:10 EET STATEMENT: select
> =A0/* $1, */
> =A0$2,
> =A0$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...

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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "d.yadagiri"
Дата:
Сообщение: unable to export database from postgres
Следующее
От: "mahmoud elzaiady"
Дата:
Сообщение: BUG #5809: bigserial duplicate value