[Buildbot] #3622: Darcs revisions break postgres

Buildbot trac trac at buildbot.net
Mon Oct 10 08:44:59 UTC 2016

#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

More information about the bugs mailing list