[Top][All Lists]
[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
pgpCjzwAqU09f.pgp
Description: PGP signature
- Re: [Gnumed-devel] A question re demographics, (continued)
- Re: [Gnumed-devel] Mistaken Patients - PNG enclosed (was: A question re demographics), Horst Herb, 2004/07/20
- Re: [Gnumed-devel] Mistaken Patients, Jim Busser, 2004/07/20
- Re: [Gnumed-devel] Mistaken Patients, Horst Herb, 2004/07/20
- Re: [Gnumed-devel] Mistaken Patients, Karsten Hilbert, 2004/07/21
- Re: [Gnumed-devel] Mistaken Patients - PNG enclosed (was: A question re demographics), Karsten Hilbert, 2004/07/21
- Re: [Gnumed-devel] Mistaken Patients - PNG enclosed (was: A question re demographics), Karsten Hilbert, 2004/07/21
- Re: [Gnumed-devel] Mistaken Patients - PNG enclosed (was: A question re demographics),
Ian Haywood <=
- Re: [Gnumed-devel] Mistaken Patients - PNG enclosed (was: A question re demographics), Karsten Hilbert, 2004/07/21
- Re: [Gnumed-devel] A question re demographics, Jim Busser, 2004/07/20
- Re: [Gnumed-devel] A question re demographics, Elizabeth Dodd, 2004/07/20
- Re: [Gnumed-devel] A question re demographics, Jim Busser, 2004/07/20
- Re: [Gnumed-devel] A question re demographics, Karsten Hilbert, 2004/07/20
- Re: [Gnumed-devel] A question re demographics, Karsten Hilbert, 2004/07/19
- Re: [Gnumed-devel] A question re demographics, Horst Herb, 2004/07/19
- Re: [Gnumed-devel] A question re demographics, Karsten Hilbert, 2004/07/19
- Re: [Gnumed-devel] A question re demographics, Karsten Hilbert, 2004/07/19