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

From Joshua D. Drake
Subject Re: Delete rule does not prevent truncate
Date
Msg-id 55B27E92.7000702@commandprompt.com
Whole thread Raw
In response to Re: Delete rule does not prevent truncate  (Andres Freund <andres@anarazel.de>)
List pgsql-general
On 07/24/2015 02:32 AM, Andres Freund wrote:
>
> On 2015-07-24 10:29:21 +0100, Tim Smith wrote:
>> 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.
>
> Oh, comeon. Install a TRUNCATE trigger and let this thread die.
>
> Andres
>

Please god, +1.

JD


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Using the database to validate data
Next
From: Jan Lentfer
Date:
Subject: Re: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away