> 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;
