| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de>, Tim Smith <randomdev4+postgres(at)gmail(dot)com> |
| Cc: | Rob Sargent <robjsargent(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Delete rule does not prevent truncate |
| Date: | 2015-07-24 18:06:10 |
| Message-ID: | 55B27E92.7000702@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Lentfer | 2015-07-24 18:06:50 | Re: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away |
| Previous Message | Jeff Janes | 2015-07-24 17:07:00 | Re: Using the database to validate data |