Re: [Mailman-Developers] listarchiver table missing from postgresql schema

Hi Aurélien,
You might then also be interested to follow the bug I submitted for this purpose: Bug #1343137 “listarchiver table missing from postgresql schema” : Bugs : GNU Mailman
Bug #1343137 “listarchiver table missing from postgresql...
I am currently testing Mailman3 with PostgreSQL and found out that the listarchiver table is missing from the PostgreSQL schema (database/schema/postgres.sql). It i...
View on bugs.launchpad.net Preview by Yahoo
On Friday, July 18, 2014 10:28 AM, Aurelien Bompard <aurelien@bompard.org> wrote:
Got hit by that too, I just created a merge request with the missing file : https://code.launchpad.net/~abompard/mailman/pgsql_upgrade/+merge/227289
Could anyone have a quick look at this?
Aurélien

On Jul 22, 2014, at 07:59 AM, 'ML mail' via barry wrote:
I'd love to apply Aurélien's patch, although as I mention in the MP, it would be good to have some tests. However, there's a bigger problem with PostgreSQL support: LP: #1170063
https://code.launchpad.net/bugs/1170063
This prevents me from running the MM3 test suite on my development machine. The patch in that bug apparently doesn't actually fix the problem and/or breaks a Storm API guarantee. I don't have any brilliant ideas on how to unstick that bug.
A while back I did look at migrating MM3 to SQLAlchemy, which would also solve one of our showstopper bugs on the way to porting to Python 3. It's not a trivial piece of work though and I'm not a SA expert. If anybody is interested in helping out here, it would be greatly appreciated.
Cheers, -Barry

I'm interested in helping port MM3 to SQLAlchemy, I've had some experience with it in the past. But first I'll add some tests to my patch, then I'll port KittyStore to SQLAlchemy, so I'll make less mistakes porting MM3, which is a significantly bigger piece.
Do you think we can release MM3 with Storm? Should we wait for the SQLAlchemy port? It's not in the TODO list on http://wiki.list.org/display/DEV/Mailman+3.0
Aurélien
2014-07-28 19:39 GMT+02:00 Barry Warsaw <barry@list.org>:

On Jul 22, 2014, at 07:59 AM, 'ML mail' via barry wrote:
I'd love to apply Aurélien's patch, although as I mention in the MP, it would be good to have some tests. However, there's a bigger problem with PostgreSQL support: LP: #1170063
https://code.launchpad.net/bugs/1170063
This prevents me from running the MM3 test suite on my development machine. The patch in that bug apparently doesn't actually fix the problem and/or breaks a Storm API guarantee. I don't have any brilliant ideas on how to unstick that bug.
A while back I did look at migrating MM3 to SQLAlchemy, which would also solve one of our showstopper bugs on the way to porting to Python 3. It's not a trivial piece of work though and I'm not a SA expert. If anybody is interested in helping out here, it would be greatly appreciated.
Cheers, -Barry

I'm interested in helping port MM3 to SQLAlchemy, I've had some experience with it in the past. But first I'll add some tests to my patch, then I'll port KittyStore to SQLAlchemy, so I'll make less mistakes porting MM3, which is a significantly bigger piece.
Do you think we can release MM3 with Storm? Should we wait for the SQLAlchemy port? It's not in the TODO list on http://wiki.list.org/display/DEV/Mailman+3.0
Aurélien
2014-07-28 19:39 GMT+02:00 Barry Warsaw <barry@list.org>:
participants (3)
-
Aurelien Bompard
-
Barry Warsaw
-
ML mail