Changes between Version 54 and Version 55 of TracMultipleProjects/ComprehensiveSolution
- Timestamp:
- Jun 21, 2008, 4:25:00 PM (16 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracMultipleProjects/ComprehensiveSolution
v54 v55 146 146 - The migration and multitrac query use schema but do not actually use the inheritance feature in postgresql, so its not clear to me how this is actually much more than a union query where the joined queries are set in a loop. If you use inheritance, you could simplify the multitrac_query to be a join like "select bar, relname from foo join pg_class on pg_class.oid=foo.tableoid;" This does not alter the trac schema at all, so I think trac DDL changes with version upgrades should work. I've modifiyed sqlite2pq and migrate.py to use inheritance. Any interest in persuing this variation on your approach? [[br]] -- karl 04/13/2008 147 147 - ''Karl, I didn't know anything about table inheritance in postgresql when I did this, but now that I look, it seems like that could be used to substantially improve on my scheme. I still don't have very strong DB-fu so I'd need some handholding, but I _would_ like to pursue your idea. Please be in touch with me at dave-AT-boostpro-dotcom. [[br]] --dave 05/29/2008 148 - Just a few lines of documentation on using migrate.py would help! [[br]] -- gautam - 06/21/2008 148 149 149 150 ----