Re: simulating row ownership - Mailing list pgsql-sql

From Ron Peterson
Subject Re: simulating row ownership
Date
Msg-id 20050111134052.GB27537@mtholyoke.edu
Whole thread Raw
In response to Re: simulating row ownership  (Ron Peterson <rpeterso@mtholyoke.edu>)
List pgsql-sql
On Tue, Jan 11, 2005 at 08:38:21AM -0500, rpeterso wrote:

> CREATE RULE lock_test_user_update
> AS ON UPDATE TO test
> WHERE old.aname = CURRENT_USER
> DO INSTEAD nothing;
> 
> CREATE RULE lock_test_user_delete
> AS ON DELETE TO test
> WHERE old.aname = CURRENT_USER
> DO INSTEAD nothing;

For your example, these rules should say !=, of course...

-- 
Ron Peterson
Network & Systems Manager
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso


pgsql-sql by date:

Previous
From: Ron Peterson
Date:
Subject: Re: simulating row ownership
Next
From: Kieran Ashley
Date:
Subject: Re: Parsing a Calculation from a field