Re: mailing list archiver chewing patches

Dimitri Fontaine <dfontaine@hi-media.com>

From: Dimitri Fontaine <dfontaine@hi-media.com>

To: Aidan Van Dyk <aidan@highrise.ca>

Cc: Matteo Beccati <php@beccati.com>, Magnus Hagander <magnus@hagander.net>, Dave Page <dpage@pgadmin.org>, Abhijit Menon-Sen <ams@toroid.org>, Alvaro Herrera <alvherre@commandprompt.com>, Andrew Dunstan <andrew@dunslane.net>, Tim Bunce <Tim.Bunce@pobox.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2010-01-12T22:10:57Z

Lists: pgsql-hackers

Aidan Van Dyk <aidan@highrise.ca> writes:
>> aox has that either as a bulk importer or as a MDA.
>
> Yup, LMTP is ideally suited for that too.

Yes.

>> > 3) A nice set of SQL queries to return message, parts, threads,
>> >    folders based on $criteria (search, id, folder, etc)
>> 
>> I guess Matteo's working on that…
>
> Right, but this is where I want to see the AOX schema "imporove"... In
> ways like adding persistant tables for threading, which are updated by
> triggers as new messages are delivered, etc.  Documented queries that
> show how to use CTEs, ltree, etc to get threaded views, good FTS support
> (with indexes and triggers managing them), etc.

+1.

I just didn't understand how much your proposal fit into current work :)
-- 
dim