Re: Prevent from Deletion

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Prevent from Deletion
Date: 2003-09-02 15:41:28
Message-ID: 3F54BA28.7020302@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

DBA's never would make the mistake of deleting a record that is a key
part of a design, of course.

;-)

Ron Johnson wrote:

>On Sun, 2003-08-31 at 22:07, Alex wrote:
>
>
>>Hi,
>>I have tables that have default records that must not be deleted or
>>modified.
>>Is there an easy way to do this. Like setting a trigger on the Primary
>>key value ?
>>
>>
>
>How about revoking DELETE and UPDATE privileges from all users
>except the DBA?
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey Melloy 2003-09-02 15:55:29 segfaults / backend crashing
Previous Message Gianni Mariani 2003-09-02 15:39:33 Re: About GPL and proprietary software