Re: DELETE with LIMIT (or my first hack)
| От | Robert Haas |
|---|---|
| Тема | Re: DELETE with LIMIT (or my first hack) |
| Дата | |
| Msg-id | AANLkTi=5EqJSm=7G+5Jctati76sNN=bX8tCD+JifQ+sM@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: DELETE with LIMIT (or my first hack) (Bruce Momjian <bruce@momjian.us>) |
| Ответы |
Re: DELETE with LIMIT (or my first hack)
|
| Список | pgsql-hackers |
On Thu, Dec 2, 2010 at 7:12 PM, Bruce Momjian <bruce@momjian.us> wrote: > Peter Eisentraut wrote: >> On tis, 2010-11-30 at 14:20 -0500, Andrew Dunstan wrote: >> > I agree, that argument is completely misconceived. If the DBA is >> > paying enough attention to use LIMIT, s/he should be paying enough >> > attention not to do damage in the first place. If that were the only >> > argument in its favor I'd be completely against the feature. >> >> I don't have any use for DELETE with LIMIT, but UPDATE with LIMIT could >> be very useful if you are doing full-table updates and you don't have >> enough space so you do it in chunks. > > So should this now be a TODO item? Text? Allow DELETE and UPDATE to be used with LIMIT and ORDER BY. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: