[Buildbot] #3622: Darcs revisions break postgres

[Buildbot trac]

#3622: Darcs revisions break postgres
----------------------+-------------------------------
Reporter:  vlstill    |      Owner:
    Type:  undecided  |     Status:  new
Priority:  major      |  Milestone:  undecided
 Version:  0.9.0b9    |   Keywords:  darcs, postgresql
----------------------+-------------------------------
 When migrating to PostgreSQL Darcs repositories stopped working, the
 reason is that darcs contexts are much longer then the table column for
 revision, which has at most 256 characters. I had to perform following
 modifications of the database:

 {{{
 ALTER TABLE sourcestamps ALTER COLUMN revision TYPE text;
 ALTER TABLE changes ALTER COLUMN revision TYPE text;
 DROP INDEX IF EXISTS "changes_revision";
 CREATE INDEX "changes_revision" ON changes USING hash ( revision );
 }}}

 Could you please change initialization of the database so that this is not
 necessary? The index change is necessary as btree indices have upper limit
 on index value size. The error was on 0.9.0rc1 (which is not in you
 selection list).

--
Ticket URL: <http://trac.buildbot.net/ticket/3622>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation