[Tickets #9835] Re: db schema update for h3->h4 conversion

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9835
------------------------------------------------------------------------------
  Ticket             | 9835
  Updated By         | sr at parabola.me.uk
  Summary            | db schema update for h3->h4 conversion
  Queue              | Horde Base
  Version            | 4.0
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


sr at parabola.me.uk (2011-07-01 20:53) wrote:

> So, the question is why? The default names for primary key  
> constraints in PostgreSQL are table_pkey. Why are yours table_idx?

I have database dumps every day for the time I have used horde. So I can tell
exactly when the unexpected primary key names appeared.

Unfortunately, it looks like I both upgraded the database and horde (to 1.2.5
from an unknown version) on that date, so I can't tell if it was an  
artefact of
the database upgrade or the horde upgrade.

I guess its possible that one of the upgrades partially failed and I  
had to fix
the primary keys by hand but I don't particularly remember doing that.  The
names do seem to be a bit inconsistent to be the result of an automatic
process.

I can investigate further if you have anything you want me to check.