[Mailman-Developers] OT: Re: user table in Mailman3 with PostgreSQL

2014-07-16 Thread Daniel Kahn Gillmor
On 07/16/2014 10:34 AM, ML mail wrote: Thanks for the trick with the double quotes to escape reserved keywords. It's probably worth reading the PostgreSQL documentation for this sort of thing: http://www.postgresql.org/docs/9.3/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS Actually I

[Mailman-Developers] listarchiver table missing from postgresql schema

2014-07-16 Thread ML mail
Hi, 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 is correctly included in SQLite migration schema though (database/schema/sqlite_2013040600_01.sql). Regards ML

Re: [Mailman-Developers] OT: Re: user table in Mailman3 with PostgreSQL

2014-07-16 Thread Barry Warsaw
On Jul 16, 2014, at 08:20 AM, 'ML mail' via barry wrote: Thanks for the details but actually I was now only asking in which table are stored the e-mail addresses of a mailing's list subscribers? I thought they would be stored in the user table but I can't see any e-mail addresses there, neither

Re: [Mailman-Developers] OT: Re: user table in Mailman3 with PostgreSQL

2014-07-16 Thread ML mail
Thanks, it all makes sense now! On Wednesday, July 16, 2014 7:20 PM, Barry Warsaw ba...@list.org wrote: On Jul 16, 2014, at 08:20 AM, 'ML mail' via barry wrote: Thanks for the details but actually I was now only asking in which table are stored the e-mail addresses of a mailing's list

Re: [Mailman-Developers] OT: Re: user table in Mailman3 with PostgreSQL

2014-07-16 Thread ML mail
Thanks, it all makes sense now! On Wednesday, July 16, 2014 7:20 PM, Barry Warsaw ba...@list.org wrote: On Jul 16, 2014, at 08:20 AM, 'ML mail' via barry wrote: Thanks for the details but actually I was now only asking in which table are stored the e-mail addresses of a mailing's list