From: | "Devi" <devi(at)visolve(dot)com> |
---|---|
To: | "Tim Rupp" <caphrim007(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: rule question |
Date: | 2008-02-29 05:21:04 |
Message-ID: | 003f01c87a92$f5bb3600$3f0110ac@devco |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-02-29 05:47:22 | Re: "Consider compacting this relation..." ??? |
Previous Message | Tom Lane | 2008-02-29 05:19:05 | Re: Text Search zero padding |