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

2011-11-29 Thread Barry Warsaw
On Nov 29, 2011, at 10:18 AM, Stephane Wirtel \(OpenERP\) wrote: >I'm interested by the support of PostgreSQL by Mailman, is there some >news for a future release with this feature ? PostgreSQL support is in Mailman 3 bzr. It will be available in beta 1, but I have no eta on that at the moment.

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