diff -r 44161dbb1518 -r 1d9bf63a86f7 create_tables.pgsql --- a/create_tables.pgsql Mon Mar 03 23:48:07 2008 +0000 +++ b/create_tables.pgsql Tue Mar 04 23:28:04 2008 +0000 @@ -90,9 +90,7 @@ CREATE OR REPLACE VIEW dovecot_user AS SELECT local_part || '@' || domains.domainname AS userid, - domains.domaindir || '/' || uid AS home, - uid, - gid + domains.domaindir || '/' || uid AS home, uid, gid FROM users LEFT JOIN domains USING (gid); @@ -101,8 +99,7 @@ FROM domains; CREATE OR REPLACE VIEW postfix_uid AS - SELECT local_part || '@' || domains.domainname AS address, - uid + SELECT local_part || '@' || domains.domainname AS address, uid FROM users LEFT JOIN domains USING (gid);