Re: mailing list archiver chewing patches

Matteo Beccati <php@beccati.com>

From: Matteo Beccati <php@beccati.com>

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

Cc: Aidan Van Dyk <aidan@highrise.ca>, 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-14T07:22:29Z

Lists: pgsql-hackers

Hi,

>>>> 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 :)

I'm looking into it. The link I've previously sent will most likely 
return a 500 error for the time being.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/