Re: "unexpected EOF" messages - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: "unexpected EOF" messages
Date
Msg-id CABUevExhiyFodmYLJXM6aGEgjvEM63GPrQiY27PsLVG3t7-k6w@mail.gmail.com
Whole thread Raw
In response to Re: "unexpected EOF" messages  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Thu, May 3, 2012 at 2:46 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Magnus Hagander  wrote:
>
>> Also, AFAIK we don't *have* a "message type" at this point (one of
>> the things said mythical project wanted to look at), so the only
>> thing we could really filter on would be the whole text of the
>> message, no?
>
> We have SQLSTATE, but this seems to be one of those situations where
> we've been sloppy about using the right value.  We seem to be using
> '08P01' (protocol_violation), which is also used for finding the
> wrong bytes on a working connection.  It seems to me a broken
> connection is exactly the case where you would expect to see '08006'
> (connection_failure).  FWIW, there are also specific exceptions for
> rejecting a connection attempt, and for attempting to send something
> when no connection exists.
>
> We don't need to invent new mechanisms for categorizing messages; we
> just need to start consistently using the one we have correctly.

While it might work a bit for this one, do we really expect to be able
to map a single SQLSTATE to each single message at any point? Unless
we can do that, it's never going to "go all the way" - though it might
still be useful of course.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: How hard would it be to support LIKE in return declaration of generic record function calls ?
Next
From: Magnus Hagander
Date:
Subject: Re: "unexpected EOF" messages