On Thu, Aug 20, 2009 at 3:16 PM, bricklen<brick...@gmail.com> wrote: > Interesting idea. Preferably this operation could be done in straight SQL in > a single transaction, to fit in with the way our application works, but if > that's not possible I may need to go the temporary table route.
Temp tables can be included in a transaction, and they're not visible to other connections. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql