Re: postgres crashing on a seemingly good query

From: Abhijit Menon-Sen <ams(at)oryx(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgres crashing on a seemingly good query
Date: 2005-02-19 17:48:01
Message-ID: 20050219174801.GA2973@penne.toroid.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 2005-02-19 21:38:56 +0530, ams(at)oryx(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2005-02-19 18:07:01 Re: postgres crashing on a seemingly good query
Previous Message Jürgen Cappel 2005-02-19 17:30:22 Re: Data loss, vacuum, transaction wrap-around