> 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; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
