Re: postgres crashing on a seemingly good query - Mailing list pgsql-hackers

From Abhijit Menon-Sen
Subject Re: postgres crashing on a seemingly good query
Date
Msg-id 20050219174801.GA2973@penne.toroid.org
Whole thread Raw
In response to postgres crashing on a seemingly good query  (Abhijit Menon-Sen <ams@oryx.com>)
Responses Re: postgres crashing on a seemingly good query  (Abhijit Menon-Sen <ams@oryx.com>)
List 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 by date:

Previous
From: Jürgen Cappel
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: postgres crashing on a seemingly good query