Re: Delete rule does not prevent truncate - Mailing list pgsql-general

From Tim Smith
Subject Re: Delete rule does not prevent truncate
Date
Msg-id CA+HuS5F180pPPpi-FrbwFcMbnPh7NtaBWaO7LVWe1WRj4aM1hg@mail.gmail.com
Whole thread Raw
In response to Re: Delete rule does not prevent truncate  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Delete rule does not prevent truncate  (Andres Freund <andres@anarazel.de>)
List pgsql-general
On 24 July 2015 at 01:37, Rob Sargent <robjsargent@gmail.com> wrote:

> Fair enough but both blackhats and the authorized are just as likely to drop
> the database as truncate something (intentionally or not) and backups
> stashed everywhere is the first order of business.


That's not the point.  Backups are important, but so is the concept of
various layers of anti-fat-finger protection.   Restoring off backups
should be last resort, not first.


pgsql-general by date:

Previous
From: 林士博
Date:
Subject: Re: Re: The fastest way to update thousands of rows in moderately sized table
Next
From: Andres Freund
Date:
Subject: Re: Delete rule does not prevent truncate