|
From: | Jim Busser |
Subject: | Re: [Gnumed-devel] Medication tweaks |
Date: | Mon, 20 Jun 2011 19:58:42 -0700 |
If desiring to replace all existing drugs in
one must first (presumably) delete all which might be linked to the above, in for example ref.branded_drugand -- before even doing this -- one must be willing to delete all cases where the drug is currently used with a patient (for example Kirk) and so, *provided* there is complete certainty that there is no clinical data needed for any patients in the production database (in which Kirk's record might still live), can one do set default_transaction_read_only to off; DELETE FROM clin.lnk_substance2episode; DELETE FROM clin.substance_intake; DELETE FROM ref.consumable_substance; DELETE FROM ref.lnk_substance2brand; DELETE FROM ref.branded_drug; DELETE FROM ref.consumable_substance; and does the above then need a commit; ?? and after the above, would views such as the following need repairing, or would they auto-refresh
-- Jim |
[Prev in Thread] | Current Thread | [Next in Thread] |