Re: hashed spool directories

3 msg	Re: Virtual domain aliases
4 msg	address verify vs. virtual_alias_maps
20 msg	Postfix/ClamAV Config Error
4 msg	smtp /dev/poll problem
6 msg	Addresses filtering for only one supported domain
14 msg	Greylist question
1 msg	One transport with AUTH and other transport wit...
7 msg	Is this expected reject behavior for foreign IP...
3 msg	relay_domains and virtual_mailbox_domains not w...
2 msg	Need help debugging a possible content filter p...
11 msg	spam emails with \| in front of the email addresses
9 msg	unexpected domain rewrite (by postfix?)
5 msg	Error receiving email
20 msg	Postfix 2.5-20071111, smtp.gmail.com, bouncing ...
1 msg	Bounce notification configure
45 msg	Re: Recipient validation
2 msg	Use of MySQL for lookups
8 msg	proposal: change behavior with respect to recip...
11 msg	OT: Any bad DKIM experiences?

hashed spool directories
\ Ron Peterson (26 Nov 2007)
. \ Victor Duchovni (26 Nov 2007)
. . \ Ron Peterson (26 Nov 2007)
. . . \ Victor Duchovni (26 Nov 2007)
. . . \ mouss (26 Nov 2007)
. . . . \ Ron Peterson (27 Nov 2007)
. . . . . \ mouss (27 Nov 2007)
. . . . . . \ Victor Duchovni (27 Nov 2007)

Subject:	Re: hashed spool directories
Group:	Postfix-users
From:	Victor Duchovni
Date:	27 Nov 2007

On Tue, Nov 27, 2007 at 12:01:55PM +0100, mouss wrote:

> you can either "compute" the result dynamically (SUBSTRING family
> functions) or compute this in advance using a trigger. If you have the
> necessary privileges, the trigger may be a better option (if you don't
> want to clutter your tables, use a table just for this).

Be careful when computing filenames from addresses, sanity checks on
the character class are a good idea (though if user names in the database
are known to be safe a-priori, pulling characters out of valid data is
not unreasonable). With stored names, I would avoid complex queries and
just store an explicit path in the database.

--
Viktor.

Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the "Reply-To" header.

To unsubscribe from the postfix-users list, visit
http://www.postfix.org/lists.html or click the link below:
<mailto:majordomo?body=unsubscribe%20postfix-users>

If my response solves your problem, the best way to thank me is to not
send an "it worked, thanks" follow-up. If you must respond, please put
"It worked, thanks" in the "Subject" so I can delete these quickly.