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>)
Список pgsql-hackers
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
Дата:
Сообщение: Re: Data loss, vacuum, transaction wrap-around
Следующее
От: Abhijit Menon-Sen
Дата:
Сообщение: Re: postgres crashing on a seemingly good query