How to isolate the result of SELECT's? - Mailing list pgsql-general

From Andre Lopes
Subject How to isolate the result of SELECT's?
Date
Msg-id CAGFRAbPa5kk1xx9U_-jF+_Q6avimW=jHBtNphchVP4XJ0R9N=g@mail.gmail.com
Whole thread Raw
Responses Re: How to isolate the result of SELECT's?  (Michael Nolan <htfoot@gmail.com>)
Re: How to isolate the result of SELECT's?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: How to isolate the result of SELECT's?  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
Re: How to isolate the result of SELECT's?  (Kiriakos Georgiou <kg.postgresql@olympiakos.com>)
List pgsql-general
Hi,

I need to do an operation that I will use some SELECT's and get the
results, but I want to have sure that those tables have not been
changed with INSERT's or UPDATES during the operation.

Example:

BEGIN OPERATION
Select field from table1;
...
Select other_field from table2;
...
END OPERATION

How can I lock these tables to assure that the tables are not getting
INSERTS's or UPDATE's during the operation?

Best Regards,

pgsql-general by date:

Previous
From: Florent THOMAS
Date:
Subject: Multi server query
Next
From: Michael Nolan
Date:
Subject: Re: How to isolate the result of SELECT's?