Reconfirmation on first error when deleting multiple records - Mailing list pgadmin-hackers

From Robins Tharakan
Subject Reconfirmation on first error when deleting multiple records
Date
Msg-id 36af4bed0802271123j16acbd93t7c8344bec6eac4f0@mail.gmail.com
Whole thread Raw
Responses Re: Reconfirmation on first error when deleting multiple records
List pgadmin-hackers
Hi,

While deleting a few (400!) records from a master table (in a development database), I realised that PgAdmin just wouldn't stop displaying 400 error messages informing that each of the deletes failed (in this case because a foreign key dependency would not allow the delete to succeed).

I think a good solution to this would be that after the initial confirmation for deletion in EditGrid, the first error (during delete process) should allow the user to cancel further deletes. This can help a great deal, for e.g. in cases when the user realises his mistake as soon as the first error pops up.

Attached is a patch to do the same. Note, that the 'reconfirmation' is done only on the first error. So this takes care of another possible case when the users 'knows' that some random 20 out of his 500 deletes would fail !

Regards,
Robins Tharakan
Attachment

pgadmin-hackers by date:

Previous
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r7105 - trunk/pgadmin3/pgadmin/schema
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r7106 - in trunk/pgadmin3: . pgadmin/frm pgadmin/ui