Re: [Debconf-team] blanking bank information from penta

[Gunnar Wolf <gwolf@gwolf.org>]

Richard Darst dijo [Tue, Jun 28, 2011 at 04:56:39PM -0400]:
> And here is the code:
> 
> BEGIN;
> UPDATE person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL;
> COMMIT;
> 
> To blank logs, too:
> BEGIN;
> UPDATE log.person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL;
> COMMIT;
> 
> It might be wise for someone who claims to know SQL (not me) check
> these.  I'm also not sure if I missed something obvious here making
> the code invalid...

Oh, and FWIW - your queries look sane. The BEGIN and COMMIT statements
are not needed, but won't hurt.