Re: rule question

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
>
>