What I did was create a different user per project in postgres with a different schema per user. Common tables between all projects live in the public schema and others are in the "project" schemas. Since by default postgress searches a schema named for the user and then public you just need to make sure the ticket tables are not in the "project" schemas.
Does that make sense? Greg On Tue, 2006-05-30 at 18:19 -0600, Randy How wrote: > > We're in the process of creating and moving various projects into > Trac. My question is regarding how to create reports OR make queries > to generate a single list of "My Active and Critical Tickets in All > Projects"? Our Trac project databases are in Postgres. > > Any help/suggestions would be appreciated, Thanks, > > Randy - rhow[at]i3.com > _______________________________________________ > Trac mailing list > [email protected] > http://lists.edgewall.com/mailman/listinfo/trac _______________________________________________ Trac mailing list [email protected] http://lists.edgewall.com/mailman/listinfo/trac
