Re: Multiple result sets

["Adam Rich" <adam.r@xxxxxxxxxxxxx>]

> I need that 5 queries, fired from the same ajax request to a web
> python application, see the same database snapshot. The driver is
> psycopg2.
> 
> Since postgresql 8.2 functions can't return multiple result sets what
> would be the best aproach?
> 

You want to set your transaction isolation to "Serializable".
Then execute your 5 queries via the same connection, and the same
Transaction.

You can do that with this command:

BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;