On 11 December 2013 15:35, Peter Kroon <plakroon(at)gmail(dot)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