[Koha-bugs] [Bug 11384] Koha should not use "ctid" as a column name

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11384

--- Comment #14 from Chris Nighswonger <cnighswonger at foundations.edu> ---
(In reply to Fridolin SOMERS from comment #13)
> (In reply to Katrin Fischer from comment #12)
> > While testing for the existance of the table is good - it worries me a bit,
> > that the table is not there. I got the table on my installations.
> Indeed, this table exists since 3.2

Interesting and a bit disconcerning since this DB began with a 3.0 installation
and has moved along ever since. It provokes a few not-necessarily-new thoughts:

1. We should probably "stamp" a new database when it is created with the
original rev number it was created under. This field would never change and
could be used to somehow "verify" that the current DB structure at any point in
time was, indeed, current.

2. There should definitely be some mechanism in place to veryify the existence
of tables prior to "working" on them during upgrades.

3. When dealing with essential tables, there should be a mechanism to throw a
rather large warning to the user when one of them is found missing, even if
there is no "easy" way to fix it because what you don't know can, indeed, hurt
you.

But we have beat around this bush before, so I just list them here for
posterity's sake. :-)

-- 
You are receiving this mail because:
You are watching all bug changes.