On Tuesday 30 November 2010 20:24:52 Marko Tiikkaja wrote: > > On 11/30/2010 02:12 PM, Kevin Grittner wrote: > >> Daniel Loureiro<dan...@termasa.com.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. > > I don't buy the argument either; why would you put a LIMIT there and > delete one row by accident when you could put a BEGIN; in front and not > do any damage at all? Because the delete of the whole table may take awfully long?
Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers