In some cases the constraints will propagate the delete, in other cases they won't. These differences are by design. There are good design reasons for no letting "delete biblio" table
Hi Robin,
I'm aware about turning foreign keys constrains off is risky, what I was trying to know is how risky could be, but OK, I realize that depends of each database, and always a bad idea.
So at least we can say manual (and also bulkmarkimport.pl -d
Hi , We would like to upgrade the version of our Koha 3.12 to 3.16 Will this affect any configurations we have on the 3.12 ??. I mean will it affect the patrons data ??. Thanks Olawale Ilesanmi S. Olawale Web & Systems Admin. ZACCHEUS ONUMBA DIBIAEZUE MEMORIAL LIBRARIES 196, Awolowo Road, Ikoyi, P O Box 52829, Ikoyi Lagos State, Nigeria. RC 12224 ----- Original Message ----- From: koha@lists.katipo.co.nz To: Cc: Sent:Wed, 25 Jun 2014 12:00:01 +1200 Subject:Koha Digest, Vol 104, Issue 54 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Wipe Koha database (just auth and biblio records) (Pablo Bianchi) 2. Re: Wipe Koha database (just auth and biblio records) (Tomas Cohen Arazi) ---------------------------------------------------------------------- Message: 1 Date: Tue, 24 Jun 2014 16:38:59 -0300 From: Pablo Bianchi To: Robin Sheat Cc: Koha-org - List Subject: Re: [Koha] Wipe Koha database (just auth and biblio records) Message-ID: Content-Type: text/plain; charset=UTF-8 Hi Robin, I'm aware about turning foreign keys constrains off is risky, what I was trying to know is how risky could be, but OK, I realize that depends of each database, and always a bad idea. So at least we can say manual (and also bulkmarkimport.pl -d option) should be updated (MySQL >~5.5)* adding a note about DELETE FROM biblio way not always will work right away. This bring us to: propagate in all/any cases? Propagation in any case will make really simple to update manual and bulkmarkimport. *I'll then fill a bug report about this two issues (manual and bulkmarkimport -d option) update. ?Regards, Pablo ? ------------------------------ Message: 2 Date: Tue, 24 Jun 2014 16:42:09 -0300 From: Tomas Cohen Arazi To: Pablo Bianchi Cc: Koha-org - List Subject: Re: [Koha] Wipe Koha database (just auth and biblio records) Message-ID: Content-Type: text/plain; charset=UTF-8 Pablo, you might as well import using the web tool, which handles deletion too. On Tue, Jun 24, 2014 at 4:38 PM, Pablo Bianchi wrote: option)
should be updated (MySQL >~5.5)* adding a note about DELETE FROM biblio way not always will work right away. This bring us to:
In some cases the constraints will propagate the delete, in other cases they won't. These differences are by design. There are good design reasons for no letting "delete biblio" table propagate in all/any cases? Propagation in any case will make really simple to update manual and bulkmarkimport.
*I'll then fill a bug report about this two issues (manual and bulkmarkimport -d option) update.
?Regards, Pablo ? _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Tom?s Cohen Arazi Prosecretar?a de Inform?tica Universidad Nacional de C?rdoba ? +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 104, Issue 54 *************************************