Revision number stored as text field

[anonymous]

When using the postgres backend, trac creates the 'rev' column in the 'revision' table as a text field. This is quite wrong. I'm not sure if there are similar mistakes in other tables since I did not check.

trac=# \d revision;
    Table "public.revision"
 Column  |  Type   | Modifiers
---------+---------+-----------
 rev     | text    | not null
 time    | integer |
 author  | text    |
 message | text    |

[Christian Boos]

This is by design. Trac support other VersioningSystemBackend than Subversion and the revision is not always a number.

[anonymous]

Fair enough. Although it seems like it should only be set to text for backends that actually require it. For example, SVN never needs text as the revision is always a whole number.

[Christian Boos]

Not even that, as you're free to keep an existing Trac environment and at any time change the repository_type and resync. Bye SVN, hello Darcs or some other fancy system ;-)

Ok, in theory you could drop the table and recreate it differently, but we don't do such things in general in Trac outside of the database schema upgrade process.