Re: [Mailman-Developers] [Bug 860159] Re: Mailman 3.0 support for Postgres

2011-09-26 Thread Barry Warsaw
On Sep 26, 2011, at 09:11 PM, Dan MacNeil wrote: >Foreign key constraints are available in sqlite 3.6.19 and above. They are >turned off by default. They can be enabled with: > > PRAGMA foreign_keys = ON; > >More details at: > http://www.sqlite.org/foreignkeys.html Thanks.

Re: [Mailman-Developers] [Bug 860159] Re: Mailman 3.0 support for Postgres

2011-09-26 Thread Dan MacNeil
On 09/26/2011 09:03 PM, Barry Warsaw wrote: Currently, two foreign key constraints are commented out because those are violated in Mailman 3 (apparently this doesn't bother SQLite). Foreign key constraints are available in sqlite 3.6.19 and above. They are turned off by default. They can be

Re: [Mailman-Developers] [Bug 860159] Re: Mailman 3.0 support for Postgres

2011-09-26 Thread Barry Warsaw
On Sep 27, 2011, at 12:44 AM, Stephen A. Goss wrote: >I've attached a branch with the Postgres support code that I've cooked >up. Fantastic, thanks! Do be sure to add a merge proposal. >3. There is now an alternate mailman_pg.sql file which is used to create >the tables. Currently, two foreign