[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-bugs] Inbox items carried across a database upgrade
From: |
Busser, Jim |
Subject: |
Re: [Gnumed-bugs] Inbox items carried across a database upgrade |
Date: |
Wed, 28 Jan 2015 13:34:26 +0000 |
On 2015-01-28, at 2:52 AM, Karsten Hilbert <address@hidden> wrote:
>> but does <gm-dbo> also become the pseudo-source of
>> user-created inbox messages, by virtue of becoming the user
>> who "modified" these items as a result of inserting the
>> records from the old database into the new one?
>
> It shouldn't (because the database isn't "copied" at the
> *logical* level but rather "cloned" at the physical level so
> the items don't really get modified, unless, of course, they
> do, courtesy of some SQL upgrade script at which point they
> may indeed). Have you observed differently ?
I cannot say for sure … among the items in my database's inbox was one that has
been sitting there for a couple of years but which I had forgotten about, by
virtue of its association to LMcC and it was seldom that, even on those
occasions when I did log in "as" LMcC, I paid attention to the inbox.
Therefore I cannot recall whether the item was originally created as a demo
item in the course of one of the database upgrades, and whether I might have
simply altered its content, or whether it was an item that I had personally as
LcMc or myself created, and which became "taken over" by gm-dbo.
The thing that made me suspicious was its acquiring an fkey to a patient.
But as it's a one-off observation I'll simply try to notice if I see this again.
-- Jim