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" <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
