Commiting after certain no of rows have been deleted - Mailing list pgsql-sql

From Smita Mahadik
Subject Commiting after certain no of rows have been deleted
Date
Msg-id 006d01c60278$2943d440$86ea52c7@smita
Whole thread Raw
Responses Re: Commiting after certain no of rows have been deleted
List 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

pgsql-sql by date:

Previous
From: "Michael Farewell"
Date:
Subject: Problem obtaining MAX values FROM TABLE
Next
From: Matthew Smith
Date:
Subject: Help on a complex query (avg data for day of the week)