Reconfirmation on first error when deleting multiple records

From: "Robins Tharakan" <tharakan(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Reconfirmation on first error when deleting multiple records
Date: 2008-02-27 19:23:50
Message-ID: 36af4bed0802271123j16acbd93t7c8344bec6eac4f0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
multiple_record_delete.patch text/x-patch 983 bytes

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2008-02-27 20:51:02 SVN Commit by dpage: r7106 - in trunk/pgadmin3: . pgadmin/frm pgadmin/ui
Previous Message svn 2008-02-27 16:02:14 SVN Commit by dpage: r7105 - trunk/pgadmin3/pgadmin/schema