gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Mistaken Patients - PNG enclosed (was: A question re


From: Ian Haywood
Subject: Re: [Gnumed-devel] Mistaken Patients - PNG enclosed (was: A question re demographics)
Date: Wed, 21 Jul 2004 17:47:51 +1000

On Wed, 21 Jul 2004 08:26:42 +0200
Karsten Hilbert <address@hidden> wrote:


> A bit trickier. Yes, that'd include finding all the rows in
> all the tables that link to the wrong episode and relink them
> to the correct one. Finding nearly all of them can be done
> through clin_root_item. Updating them can NOT be done through
> clin_root_item, unfortunately, as PostgreSQL inheritance
> limitations doesn't allow that to happen properly.
However you can find the descendant table from the system column 'tableoid'.
So you can do this programmatically (just rather slowly, because a separate 
UPDATE
has to be issued for each descendant table)

Ian

-- 
PGP public key E750652E at wwwkeys.pgp.net
9BF0 67B7 F84F F7EE 0C42  C063 28FC BC52 E750 652E

Attachment: pgpCjzwAqU09f.pgp
Description: PGP signature


reply via email to

[Prev in Thread] Current Thread [Next in Thread]