How to isolate the result of SELECT's?
| От | Andre Lopes |
|---|---|
| Тема | How to isolate the result of SELECT's? |
| Дата | |
| Msg-id | CAGFRAbPa5kk1xx9U_-jF+_Q6avimW=jHBtNphchVP4XJ0R9N=g@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: How to isolate the result of SELECT's?
Re: How to isolate the result of SELECT's? Re: How to isolate the result of SELECT's? Re: How to isolate the result of SELECT's? |
| Список | 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 по дате отправления: