Skip site navigation (1) Skip section navigation (2)

Re: DELETE with LIMIT (or my first hack)

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Mario Weilguni <roadrunner6(at)gmx(dot)at>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: DELETE with LIMIT (or my first hack)
Date: 2010-12-01 18:08:49
Message-ID: AANLkTimFLZpDp_gLHqkK117e-UfTVkY0veaqNiKBALED@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hey,

I don't clearly understand why anybody should perform DELETE
directly from a psql terminal on a production system. WHY ?
I can't understand what problem with DELETE without WHERE clause
for application developers and why DBMS should "protect" them
from DELETE FROM table.

PS. Anybody can perform rm -rf from the shell as root. So what ?..


2010/12/1 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>

> Mario Weilguni <roadrunner6(at)gmx(dot)at> wrote:
>
> > Is it really up to the database to decide what queries are ok?
> > It's the task of the developers to test their applikations.
>
> We're talking about ad hoc queries here, entered directly through
> psql or similar.
>
> -Kevin
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>



-- 
// Dmitriy.

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-12-01 18:09:05
Subject: Re: We really ought to do something about O_DIRECT and data=journalled on ext4
Previous:From: Josh BerkusDate: 2010-12-01 18:07:11
Subject: Re: DELETE with LIMIT (or my first hack)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group