Re: Reconfirmation on first error when deleting multiple records

On Wed, Feb 27, 2008 at 7:23 PM, Robins Tharakan <tharakan(at)gmail(dot)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