Re: simulating row ownership

From: Ron Peterson <rpeterso(at)mtholyoke(dot)edu>
To: Rick Schumeyer <rschumeyer(at)ieee(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: simulating row ownership
Date: 2005-01-11 13:40:52
Message-ID: 20050111134052.GB27537@mtholyoke.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-01-11 14:45:36 Single row tables
Previous Message Ron Peterson 2005-01-11 13:38:21 Re: simulating row ownership