Postgres Pro
Downloads
Home   >   mailing lists

For SELECT statement (just a reading one, no 'FOR UPDATE'), is COMMITor ROLLBACK preferred? - Mailing list pgsql-general

From David Wall
Subject For SELECT statement (just a reading one, no 'FOR UPDATE'), is COMMITor ROLLBACK preferred?
Date
Msg-id 3e16442c-a60a-679a-e72e-6d895552b6f8@computer.org
Whole thread Raw
Responses Re: For SELECT statement (just a reading one, no 'FOR UPDATE'), isCOMMIT or ROLLBACK preferred?
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgres SQLSTATE[08006] [7] timeout expired
Next
From: Rob Sargent
Date:
Subject: Re: Postgres SQLSTATE[08006] [7] timeout expired