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.
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 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 Berkus||Date: 2010-12-01 18:07:11|
|Subject: Re: DELETE with LIMIT (or my first hack)|