Re: DELETE with LIMIT (or my first hack)

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема Re: DELETE with LIMIT (or my first hack)
Дата
Msg-id 4CF660F7.3080106@gmx.at
обсуждение исходный текст
Ответ на Re: DELETE with LIMIT (or my first hack)  (Rob Wultsch <wultsch@gmail.com>)
Ответы Re: DELETE with LIMIT (or my first hack)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Am 01.12.2010 15:37, schrieb Rob Wultsch:
> "For beginners, a useful startup option is --safe-updates (or
> --i-am-a-dummy, which has the same effect). This option was introduced
> in MySQL 3.23.11. It is helpful for cases when you might have issued a
> DELETE FROM tbl_name statement but forgotten the WHERE clause.
> Normally, such a statement deletes all rows from the table. With
> --safe-updates, you can delete rows only by specifying the key values
> that identify them. This helps prevent accidents.

Is it really up to the database to decide what queries are ok? It's the 
task of the developers to test their applikations.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: crash-safe visibility map, take three
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Proposal: First step towards Intelligent, integrateddatabase