Opened 8 years ago

Last modified 7 years ago

#1311 assigned defect

Incompatible with PostgreSQL

Reported by: jajcus@… Owned by: cygnus
Priority: normal Component: OpenidPlugin
Severity: normal Keywords: PostgreSQL SQL BLOB
Cc: Trac Release: 0.10


OpenID plugin will make Trac unusable when PostgreSQL database is used for storage. That is because it uses non-standard SQL features: "BLOB" type (this may be replaced with BYTEA for PostgreSQL) and "REPLACE INTO" ("DELETE FROM" + "INSERT" should be used instead, two commands instead one are no problem when transactions are in use).

Attachments (0)

Change History (2)

comment:1 Changed 8 years ago by cygnus

  • Status changed from new to assigned

comment:2 Changed 7 years ago by dalius

If you want you can test this problem with AuthOpenIdPlugin which uses newer version of OpenID library and uses internal routines for handling different databases.

Add Comment

Modify Ticket

as assigned The owner will remain cygnus.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.