Re: PG Email Client - Mailing list pgsql-general

From Sim Zacks
Subject Re: PG Email Client
Date
Msg-id epmmo9$msc$1@news.hub.org
Whole thread Raw
In response to Re: PG Email Client  (Tino Wildenhain <tino@wildenhain.de>)
Responses Re: PG Email Client
Re: PG Email Client
List pgsql-general
  > Err... I do not understand "copy an email in 1 folder" - I use
> IMAP which stores all the mail on the server.
> (That is what dbmail does too)

In the traditional imap server the mail is stored in folders on the server that are accessed by the
client. Therefore you are limited to one indexed location per email. Lets say you want to look at
your email by customer. You would want to have a folder per customer so you can review your
correspondence with each one individually. If you want to look at correspondence per product. You
would need one folder for each product so you can review the correspondence for each product
individually.
However, if you want to have the ability to look at your email both per customer and per product,
then with the traditional imap system, you would need to copy the email so you had two physical
copies of the email. Now if you wanted to make notes on the email, it would only be tied to one of
them, etc..
I haven't checked whether dbmail can make virtual folders yet based on queries, but the normal
clients certainly don't support setting up indexes on the emails so that they could be viewed in
both folders.
A client that took advantage of a database backend would be one in which the user could
a) create virtual folders that are actually queries
b) choose indexes or put in keywords so that whether you clicked on the Customer A folder or the
Product C folder you would see the exact same e-mail.

pgsql-general by date:

Previous
From: "Denis Lussier"
Date:
Subject: pg migrator
Next
From: Michael Fuhr
Date:
Subject: Re: encode, lower and 0x8a