X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B12513A551A for ; Tue, 11 Jan 2005 13:41:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89674-03 for ; Tue, 11 Jan 2005 13:40:51 +0000 (GMT) Received: from pagoda.mtholyoke.edu (pagoda.mtholyoke.edu [138.110.30.68]) by svr1.postgresql.org (Postfix) with ESMTP id 64DE73A57BC for ; Tue, 11 Jan 2005 13:40:53 +0000 (GMT) Received: from pagoda.mtholyoke.edu (rpeterso@pagoda [127.0.0.1]) by pagoda.mtholyoke.edu (8.12.11/8.12.11/Debian-5) with ESMTP id j0BDeqTH027706; Tue, 11 Jan 2005 08:40:52 -0500 Received: (from rpeterso@localhost) by pagoda.mtholyoke.edu (8.12.11/8.12.11/Debian-5) id j0BDeqFT027703; Tue, 11 Jan 2005 08:40:52 -0500 From: Ron Peterson Date: Tue, 11 Jan 2005 08:40:52 -0500 To: Rick Schumeyer , pgsql-sql@postgresql.org Subject: Re: simulating row ownership Message-ID: <20050111134052.GB27537@mtholyoke.edu> Mail-Followup-To: Rick Schumeyer , pgsql-sql@postgresql.org References: <001901c4f4d9$395726f0$0200a8c0@dell8200> <20050111133821.GA27537@mtholyoke.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050111133821.GA27537@mtholyoke.edu> Organization: Mount Holyoke College X-Operating-System: Debian GNU/Linux User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.107 tagged_above=0 required=5 tests=AWL, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200501/37 X-Sequence-Number: 19825 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