On 11 December 2013 15:35, Peter Kroon <plakr...@gmail.com> wrote: > Perhaps creating a temporary table would be more efficient. > Then the rollback isn't necessary. > > > Yep, but only if you're sure that you don't have queries which change other parts of the database, including calling procedures which could change data or structure. That's why I like the fact that even DDLs are transactional in Postgres :)
Szymon
