On 03/18/2012 04:33 PM, Andre Lopes wrote:
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?
Rather than replicate the docs in a post, I suggest you take a look at:
http://www.postgresql.org/docs/9.1/interactive/mvcc.html
It explains the various options you have very well.
Best Regards,
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
