Thread: Reconfirmation on first error when deleting multiple records
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
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
On Wed, Feb 27, 2008 at 7:23 PM, Robins Tharakan <tharakan@gmail.com> wrote: > 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 ! Cool - applied to SVN with just a minor change to use a bool rather than an int as the 'show message' flag. Thanks! -- Dave Page EnterpriseDB UK Ltd: http://www.enterprisedb.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk