Re: DELETE with LIMIT (or my first hack) - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: DELETE with LIMIT (or my first hack)
Date
Msg-id 4CF660F7.3080106@gmx.at
Whole thread Raw
In response to Re: DELETE with LIMIT (or my first hack)  (Rob Wultsch <wultsch@gmail.com>)
Responses Re: DELETE with LIMIT (or my first hack)
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: crash-safe visibility map, take three
Next
From: Andrew Dunstan
Date:
Subject: Re: Proposal: First step towards Intelligent, integrateddatabase