From: | Péter Kovács <maxottovonstirlitz(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Finding out on exactly what I am stuck |
Date: | 2009-04-13 16:13:02 |
Message-ID: | fdeb32eb0904130913k40ec070ag9154722df4b1c619@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Reproducing the exact sequence of events would be very difficult.
Essentially, the same JDBC connection was used simultaneously (in
multiple threads) for various selects and updates, which is a bad
enough thing to do, I presume, as the connection instance is not
thread-safe. I don't think that much should be invested in helping
detect programming errors like this. Let the onus of dealing with such
situations rest on the application programmers -- it is their fault
anyway. (Oracle makes it somewhat [not significantly much] more easier
to do this, but I find it normal that customers get at least some
extra features for their bucks.)
Thanks
Peter
2009/4/13 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> Péter Kovács <maxottovonstirlitz(at)gmail(dot)com> wrote:
>> I found the source of the problem: the client
>> application made SQL calls in invalid sequences.
>
>> I ran the same test case against Oracle as well
>
>> it gave a more informative error message ("protocol violation");
>> and, also, the error message was emitted much closer to the place in
>> the execution path where the actual programming error occurred.
>
> Could you share information about what you did, what you would like or
> expect as an error message, and what you got instead? It might help
> us improve PostgreSQL.
>
> -Kevin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2009-04-13 16:35:29 | Re: Finding out on exactly what I am stuck |
Previous Message | Mark Dueck | 2009-04-13 15:59:11 | case insensitive like searches |