Commiting after certain no of rows have been deleted

From: Smita Mahadik <smita(dot)mahadik(at)fedex(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Commiting after certain no of rows have been deleted
Date: 2005-12-16 19:37:33
Message-ID: 006d01c60278$2943d440$86ea52c7@smita
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

In my application I m deleteing large no of rows from table based on certain condition. This takes lot of time and if sometimes my application fails it starts all over again...since the coomit is done at the end of transactions. Is there a way i can do commit when certain no of rows have been deleted? For eg if i need to delete 2 million rows i should be able to commit after say 10,000 rows.

Regards
smita

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ken Winter 2005-12-16 21:07:19 Rule causes baffling error
Previous Message Alexandre Gonçalves Jacarandá 2005-12-16 16:03:14 Re: Help on function creating