Re: local and remote storage for same user

11 msg	Reject unknown Sender address
10 msg	Postfix and archiving
5 msg	-o content_filter overrides main.cf ?
1 msg	Postfix 2.4.3 and 2.3.11 available
8 msg	SASL authentication via dovecot?
2 msg	postfix/sasl: sql_select option missing - wtf?
3 msg	max connection rate/count/limit issues.
1 msg	requeue mails
6 msg	nothing in maillog

local and remote storage for same user
\ Juan Miscaro (31 May 2007)
. \ mouss (31 May 2007)
. . \ Juan Miscaro (31 May 2007)
. . . \ Erwan David (31 May 2007)
. . . \ mouss (31 May 2007)
. . . . \ Juan Miscaro (1 Jun 2007)
. . . . . \ mouss (1 Jun 2007)
. . . . . . \ Juan Miscara (6 Jun 2007)
. . . . . . . \ mouss (7 Jun 2007)

7 msg	Rejecting Invaliud Users - Useful Resource poin...
4 msg	Distributing map files
5 msg	relay_recipient_maps for multiple destinations
13 msg	auto-responders with postfix
6 msg	Mydestination with virtual domains
6 msg	Splitting smtpd_proxy_filter in smtpd_recipient...
10 msg	Can't Send to Sprint Messaging Users..
1 msg	MAAWG meeting anyone?
2 msg	basic postfix 2.4.1 configuration for a simple ...
5 msg	Strange persistant 'timeout after DATA' from ma...

Subject:	Re: local and remote storage for same user
Group:	Postfix-users
From:	mouss
Date:	31 May 2007

Juan Miscaro wrote:
>
> I'm using an SQL backend where I have a table for system users such as
> postmaster and root that point to remote addresses and a table for my
> Maildir users. I'm sorry I don't have the proper table terminology
> (I'm temporarily locked out of my system) but the way I read your
> comment my additions should be made to the same table and that doesn't
> seem possible with my setup.
>
>

multiple tables can be joined to form a single table in multiple ways.
for example:

query = select target from db1.table1, db2.table2, .... where ....

you can also use CASE WHEN... and other statements if you only want to
do some queries in some cases.