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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Any difference between commit/rollback when only temp tables and \copy are used
Дата
Msg-id CAKFQuwbzxFebx8j3Apbx36D7Laxc0awNHu0jgtDgh1A_x5w8Bg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Any difference between commit/rollback when only temp tables and \copy are used  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Re: Any difference between commit/rollback when only temp tables and \copy are used  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Fast way to delete big table?
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: Any difference between commit/rollback when only temp tables and \copy are used