How to isolate the result of SELECT's?

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: Florent THOMAS
Дата:
Сообщение: Multi server query
Следующее
От: Michael Nolan
Дата:
Сообщение: Re: How to isolate the result of SELECT's?