id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
11015,db upgrade fails when using postgres backend,kyle.james.oconnor@…,sandinak,"Attempting to use Postgres 9.1 backend with this plugin version 1.0.2 (Trac 1.0, AccountManager 0.4.3) gives the following error:
{{{
The upgrade failed. Please fix the issue and try again.
ProgrammingError: type ""blob"" does not exist
LINE 4: ""data"" blob
}}}
it looks like ""blob"" is not a valid type for postgres. If I replace ""blob"" with ""bytea"" (patch) it works but how do we handle this in a cross database way? I have to believe there is also code in the trac DB api that can handle these types but I could not find it.",defect,closed,normal,DirectoryAuthPlugin,major,fixed,,rjollos,1.0