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
On Sun, Mar 18, 2012 at 6:33 PM, Andre Lopes lopes80an...@gmail.com 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
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;
...
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;
...
In all likelihood you do not want to do what you described (lock the tables.)
You have to have a basic understanding of MVCC and transaction isolation levels
to determine if the default behavior of mvcc + 'read committed' is sufficient.
In a lot of cases it is.
Kiriakos
On Mar 18, 2012,