Postgres Pro
Downloads
Home   >   mailing lists

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

From Andres Freund
Subject Re: Delete rule does not prevent truncate
Date
Msg-id 20150724093206.GA8637@alap3.anarazel.de
Whole thread Raw
In response to Re: Delete rule does not prevent truncate  (Tim Smith <randomdev4+postgres@gmail.com>)
Responses Re: Delete rule does not prevent truncate  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tim Smith
Date:
Subject: Re: Delete rule does not prevent truncate
Next
From: Andrew Sullivan
Date:
Subject: Re: Delete rule does not prevent truncate