Re: DELETE with LIMIT (or my first hack)

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Daniel Loureiro <daniel(at)termasa(dot)com(dot)br>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Csaba Nagy <ncslists(at)googlemail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: DELETE with LIMIT (or my first hack)
Date: 2010-11-30 19:20:00
Message-ID: 4CF54E60.2080203@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/30/2010 02:12 PM, Kevin Grittner wrote:
> Daniel Loureiro<daniel(at)termasa(dot)com(dot)br> wrote:
>
>> to me the key its security - its a anti-DBA-with-lack-of-attention
>> feature.
>
> Well, it seems pretty weak to me for that purpose. You still trash
> data, and you don't have any immediate clue as to what.

I agree, that argument is completely misconceived. If the DBA is paying
enough attention to use LIMIT, s/he should be paying enough attention
not to do damage in the first place. If that were the only argument in
its favor I'd be completely against the feature.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Tiikkaja 2010-11-30 19:24:52 Re: DELETE with LIMIT (or my first hack)
Previous Message Kevin Grittner 2010-11-30 19:12:54 Re: DELETE with LIMIT (or my first hack)