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)
            		
            		 | 
		
| Список | 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 по дате отправления: