For SELECT statement (just a reading one, no 'FOR UPDATE'), is COMMITor ROLLBACK preferred?

Поиск
Список
Период
Сортировка
От David Wall
Тема For SELECT statement (just a reading one, no 'FOR UPDATE'), is COMMITor ROLLBACK preferred?
Дата
Msg-id 3e16442c-a60a-679a-e72e-6d895552b6f8@computer.org
обсуждение исходный текст
Ответы Re: For SELECT statement (just a reading one, no 'FOR UPDATE'), isCOMMIT or ROLLBACK preferred?  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
Using the latest PostgreSQL, does it matter if my code does a ROLLBACK 
or a COMMIT on an non-modifying SELECT statement?  My impression is 
they'd be the same as nothing is changed and therefore there's nothing 
to commit or rollback, but wondered if there was any difference in how 
they are processed by Postgres?

Thanks,
David




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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Postgres SQLSTATE[08006] [7] timeout expired
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Postgres SQLSTATE[08006] [7] timeout expired