To: Andrew Sullivan <ajs@crankycanuck.ca>
cc: pgsql-www@postgresql.org
Subject: Re: Email not searchable in our archives 
In-reply-to: <20080311151645.GB1465@crankycanuck.ca> 
References: <200803110329.m2B3Tr204668@momjian.us>
	<9496.1205206660@sss.pgh.pa.us>
	<20080311111040.GA6767@alvh.no-ip.org>
	<19906.1205247463@sss.pgh.pa.us>
	<20080311151645.GB1465@crankycanuck.ca>
Comments: In-reply-to Andrew Sullivan <ajs@crankycanuck.ca>
	message dated "Tue, 11 Mar 2008 11:16:45 -0400"
Date: Tue, 11 Mar 2008 11:25:35 -0400
Message-ID: <20894.1205249135@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Andrew Sullivan <ajs@crankycanuck.ca> writes:
> On Tue, Mar 11, 2008 at 10:57:43AM -0400, Tom Lane wrote:
>> Whether it's an attachment or not is irrelevant --- the standards for
>> this don't even know that there is such a thing as an attachment.

> That's not quite right: MIME knows about message parts, which is really what
> we mean by "attachment".  My bet is that the problem (I haven't looked at
> the pieces that are doing this) is that something (mhonarc?) isn't handling
> MIME message parts correctly (maybe during the transition to mailbox
> format?).

Right, the problem is exactly that Unix mbox format knows about "From "
(and nothing else) as a message separator.  Whatever code dumps messages
into such a file *must* escape data lines beginning with "From ".

			regards, tom lane