Re: DELETE with LIMIT (or my first hack)
| От | Jaime Casanova |
|---|---|
| Тема | Re: DELETE with LIMIT (or my first hack) |
| Дата | |
| Msg-id | AANLkTimx08PcEP4gK7YxPpqNQurDMzPqa0ga5MhrskWX@mail.gmail.com обсуждение исходный текст |
| Ответ на | DELETE with LIMIT (or my first hack) (Daniel Loureiro <loureirorg@gmail.com>) |
| Ответы |
Re: DELETE with LIMIT (or my first hack)
|
| Список | pgsql-hackers |
On Mon, Nov 29, 2010 at 9:08 PM, Daniel Loureiro <loureirorg@gmail.com> wrote: > > 3) change the executor to stop after “n” successful iterations. Is > this correct ? > no. it means you will delete the n first tuples that happen to be found, if you don't have a WHERE clause that means is very possible you delete something you don't want to... the correct solution is to use always try DELETE's inside transactions and only if you see the right thing happening issue a COMMIT besides i think this has been proposed and rejected before -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL
В списке pgsql-hackers по дате отправления: