Perhaps there's something I don't understand, but I thought that messages (including attachments) were all represented using text, i.e., UTF7. Is that not the case? (If this is a n00b question feel free to refer me to an RFC, those things don't scare me).
- Naz.

Paul J Stevens wrote:
Josh Berkus wrote:
Hmmm. If you're storing stuff as MIME, you could actually put it in a TEXT field in PostgreSQL. Mind you, that just makes replication easier, it doesn't help otherwise -- both are stored using TOAST regardless.

That won't work afaik. Using TEXT would mean forcing the blob into the correct
encoding. There is not much added benefit I'm aware of, and plenty of downside.


_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to