Re: [Gnumed-devel] Upgrades contain unwanted data (for example database v17 bootstraps German ref.billable data)

[Karsten Hilbert]

On Sun, Jul 01, 2012 at 02:59:42AM +0000, Jim Busser wrote:

> and since it appeared the purpose of "ft_del_billable" was to ensure the 
> preservation, in the audit.log what I did not need preserved there, was it 
> (hopefully) ok to have done
> 
>       ALTER TABLE ref.billable
>       DISABLE TRIGGER zt_del_billable;
> 
>       delete from ref.billable where fk_data_source=
>       (select pk from ref.data_source where name_short = 'GOÄ');
> 
>       ALTER TABLE ref.billable
>       ENABLE TRIGGER zt_del_billable;
> 
>       delete from ref.data_source where name_short = 'GOÄ';
> 
> which appeared to work and to achieve what I desired to achieve??

That should work, yes.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346