db upgrade fails when using postgres backend
|Reported by:||kyle.james.oconnor@…||Owned by:||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.