Re: DELETE with LIMIT (or my first hack)
| От | Dmitriy Igrishin |
|---|---|
| Тема | Re: DELETE with LIMIT (or my first hack) |
| Дата | |
| Msg-id | AANLkTimFLZpDp_gLHqkK117e-UfTVkY0veaqNiKBALED@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: DELETE with LIMIT (or my first hack) ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Список | 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 ?..
--
// Dmitriy.
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.Grittner@wicourts.gov>
Mario Weilguni <roadrunner6@gmx.at> wrote:We're talking about ad hoc queries here, entered directly through
> Is it really up to the database to decide what queries are ok?
> It's the task of the developers to test their applikations.
psql or similar.
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
--
// Dmitriy.
В списке pgsql-hackers по дате отправления: