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.

In response to

• Re: DELETE with LIMIT (or my first hack) at 2010-12-01 14:37:22 from Rob Wultsch

Responses

• Re: DELETE with LIMIT (or my first hack) at 2010-12-01 15:13:32 from Kevin Grittner

pgsql-hackers by date

Next:	From: Kevin Grittner	Date: 2010-12-01 14:57:51
	Subject: Re: crash-safe visibility map, take three
Previous:	From: Tom Lane	Date: 2010-12-01 14:51:20
	Subject: Re: KNNGIST next step: adjusting indexAM API