Re: rule question
От | Devi |
---|---|
Тема | Re: rule question |
Дата | |
Msg-id | 003f01c87a92$f5bb3600$3f0110ac@devco обсуждение исходный текст |
Ответ на | rule question (Tim Rupp <caphrim007@gmail.com>) |
Ответы |
Re: rule question
|
Список | pgsql-general |
Hi, CREATE RULE dosen't require any lock. It is carried out in the parser level. But there will be ACCESS SHARE lock over the tables which are being queried & are acquired automatically. Thanks DEVI.G ----- Original Message ----- From: "Tim Rupp" <caphrim007@gmail.com> To: <pgsql-general@postgresql.org> Sent: Friday, February 29, 2008 8:47 AM Subject: [GENERAL] rule question > Hey list, > > Does CREATE RULE require an exclusive lock on the table it's making a rule > for? For instance, if an insert is being done on the table, and you do > 'create rule', it will wait for said insert to finish? > > Thanks, > -Tim > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: > 269.21.1/1302 - Release Date: 2/27/2008 4:34 PM > >
В списке pgsql-general по дате отправления: