Postgres Pro
Downloads
Home   >   mailing lists

Any difference between commit/rollback when only temp tables and \copy are used - Mailing list pgsql-general

From David G. Johnston
Subject Any difference between commit/rollback when only temp tables and \copy are used
Date
Msg-id CAKFQuwbzxFebx8j3Apbx36D7Laxc0awNHu0jgtDgh1A_x5w8Bg@mail.gmail.com
Whole thread Raw
Responses Re: Any difference between commit/rollback when only temp tables and \copy are used
Re: Any difference between commit/rollback when only temp tables and \copy are used
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Fast way to delete big table?
Next
From: Alan Hodgson
Date:
Subject: Re: Any difference between commit/rollback when only temp tables and \copy are used