Any difference between commit/rollback when only temp tables and \copy are used

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Any difference between commit/rollback when only temp tables and \copy are used
Date: 2016-05-16 19:41:23
Message-ID: CAKFQuwbzxFebx8j3Apbx36D7Laxc0awNHu0jgtDgh1A_x5w8Bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a psql script that obtains data via the \copy command and loads it
into a temporary table. Additional work is performed possibly generating
additional temporary tables but never any "real" tables. Then the script
outputs, either to stdout or via \copy, the results.

Does it matter whether I issue a ROLLBACK or a COMMIT at the of the
transaction? More basically: does it matter whether I issue a BEGIN?

The script runs on Ubuntu inside a bash shell's heredoc.

Thanks!

David J.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2016-05-16 19:56:57 Re: Any difference between commit/rollback when only temp tables and \copy are used
Previous Message Jeff Janes 2016-05-16 17:42:03 Re: Fast way to delete big table?