Skip site navigation (1) Skip section navigation (2)

Re: rule question

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-general

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.

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

In response to


pgsql-general by date

Next:From: Tom LaneDate: 2008-02-29 05:47:22
Subject: Re: "Consider compacting this relation..." ???
Previous:From: Tom LaneDate: 2008-02-29 05:19:05
Subject: Re: Text Search zero padding

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group