Skip site navigation (1) Skip section navigation (2)

Re: DELETE with LIMIT (or my first hack)

From: Mario Weilguni <roadrunner6(at)gmx(dot)at>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: DELETE with LIMIT (or my first hack)
Date: 2010-12-01 14:51:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.

In response to


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group