Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL infinite loop in "UPDATE/INSERT" example - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/pgSQL infinite loop in "UPDATE/INSERT" example
Date
Msg-id 2629.1251234222@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL infinite loop in "UPDATE/INSERT" example  (Michael Brown <mbrown@fensystems.co.uk>)
List pgsql-general
Tree view 
Michael Brown <mbrown@fensystems.co.uk> writes:
> I believe that Example 38-2 ("Exceptions with UPDATE/INSERT") in the PL/pgSQL
> documentation suffers from a race condition leading to a potential infinite
> loop when running at isolation level SERIALIZABLE.

You're right, it's not designed to work in serializable mode.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to simulate crashes of PostgreSQL?
Next
From: APseudoUtopia
Date:
Subject: Importing Mangled SQL File via psql