Re: Simple question on SELECT - Mailing list pgsql-general

From John R Pierce
Subject Re: Simple question on SELECT
Date
Msg-id 4EB861A3.7060908@hogranch.com
Whole thread Raw
In response to Simple question on SELECT  (Edson Richter <richter@simkorp.com.br>)
Responses Re: Simple question on SELECT  (Edson Richter <richter@simkorp.com.br>)
List pgsql-general
On 11/07/11 2:41 PM, Edson Richter wrote:
> Does simple SELECT query like
>
> select * from tableX
>
> (without FOR UPDATE) opens an implicit transaction when issued?

opens and closes.    if you don't bracket with BEGIN;  ....
COMMIT|ROLLBACK;    then each statement is a transaction of and by itself



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


pgsql-general by date:

Previous
From: Michael Musenbrock
Date:
Subject: Re: Custom Constraint Violation Errors
Next
From: Richard Broersma
Date:
Subject: Re: Custom Constraint Violation Errors