On Jun 21, 2013, at 4:25 PM, Mohsen Pahlevanzadeh wrote:
Dear all,
I read we create the following table in wiki2 : CREATE TABLE users ( userid VARCHAR(128) NOT NULL, domain VARCHAR(128) NOT NULL, password VARCHAR(64) NOT NULL, home VARCHAR(255) NOT NULL, uid INTEGER NOT NULL, gid INTEGER NOT NULL );
But i read the following text in the official postfix documentation : "DO create tables with each matching item as a key and with an arbitrary value. With SQL databases it is not uncommon to return the key itself or a constant value." ref: http://www.postfix.org/mysql_table.5.html
How can i combine together?
I'm not sure I understand you problem but for dovecot and postfix the important thing is to return the query result that meets your needs. How the tables are create and related does not really matter. If you are having problems it is most likely your select query.
Regards, Bradley Giesbrecht (pixilla)