Re: postgres crashing on a seemingly good query

Поиск
Список
Период
Сортировка
Искать
От
Abhijit Menon-Sen
Тема
Re: postgres crashing on a seemingly good query
Дата
Msg-id
20050219174801.GA2973@penne.toroid.org
Ответ на
Список
Дерево обсуждения
postgres crashing on a seemingly good query Abhijit Menon-Sen <ams@oryx.com>
Re: postgres crashing on a seemingly good query Abhijit Menon-Sen <ams@oryx.com>
Re: postgres crashing on a seemingly good query Abhijit Menon-Sen <ams@oryx.com>
Re: postgres crashing on a seemingly good query Abhijit Menon-Sen <ams@oryx.com>
Re: postgres crashing on a seemingly good query Tom Lane <tgl@sss.pgh.pa.us>
Re: postgres crashing on a seemingly good query Neil Conway <neilc@samurai.com>
Re: postgres crashing on a seemingly good query Tom Lane <tgl@sss.pgh.pa.us>
At 2005-02-19 21:38:56 +0530, ams@oryx.com wrote:
>
> I couldn't reproduce this with SQL PREPARE/EXECUTE statements in psql,
> so I conjectured that it may have something to do with the parameter
> types being unspecified. I added a statement-describe message between
> the parse and the bind, however, and the server had correctly inferred
> all of the types (23/23/25/17/17, i.e. INT4/INT4/TEXT/BYTEA/BYTEA).

Another data point: If I change my code (by means of an unspeakably vile
hack, but never mind that) to specify each parameter types in the parse
message, the server no longer crashes.

Any ideas?

-- ams

В списке pgsql-hackers по дате отправления
От: Jürgen Cappel
Дата:
От: Abhijit Menon-Sen
Дата:
FAQ