Re: Serializable transactions and SQLException

On Friday 29 October 2004 04:19, you wrote:
>
> ... omissis...
>
> If you are connected to a >= 7.4 server getSQLState will have a value for
> this error.  The best way to identify it and make sure you code works on
> other database platforms is to actually write a small test case to
> generate this error and grab the error code.  PG will always return
> the same error code, but other databases may not use the same one and the
> best way to find out is actually testing.

Thank you everybody for the prompt help.

I see your replies suggest to switch to a 7.4 or earlier version. I have 7.3.2
in my production environment. What is supposed to solve a >=7.4 server in
relation to serializable isolation?

Thanks again,

    Giampaolo Tomassoni