[Bug 860159] Re: Mailman 3.0 support for Postgres

[Stephen A. Goss]

I've attached a branch with the Postgres support code that I've cooked
up.

Some notes:

1. You must install Storm trunk (or v. 0.19 whenever that is released)
as version 0.18 is broken w/regards to Postgres and UUID columns.

2. I haven't adapted the test suite to run against Postgres, yet, but my
own external integration tests pass (which encompass quite a bit of
functionality).

3. There is now an alternate mailman_pg.sql file which is used to create
the tables. Currently, two foreign key constraints are commented out
because those are violated in Mailman 3 (apparently this doesn't bother
SQLite). Some column TYPES are different from mailman.sql. Classes are
created in a slightly different order due to FK constraint creation
requires the referenced table to actually exist. The primary key indexes
defined after each class are probably redundant, as those are created
automatically for SERIAL columns defined as PRIMARY KEY in Postgres.

4. Probably more FK constraint violations exist that my tests haven't
uncovered.

-- 
You received this bug notification because you are a member of Mailman
Coders, which is subscribed to GNU Mailman.
https://bugs.launchpad.net/bugs/860159

Title:
  Mailman 3.0 support for Postgres

To manage notifications about this bug go to:
https://bugs.launchpad.net/mailman/+bug/860159/+subscriptions