Is there any reason foreign keys have been removed from the schema?
Or can I send a patch in that adds them back for the schema? Foreign
keys are great anti-foot shooting measures. -sc
Foreign key were *not* removed from the schema. Whatever gave you that
idea?
egrep(1).
cd ~/open_source/dbmail/sql/postgresql/
% egrep -i '(key|constraint)' create_tables.pgsql
PRIMARY KEY (alias_idnr)
PRIMARY KEY (user_idnr)
PRIMARY KEY (mailbox_idnr)
PRIMARY KEY (user_id, mailbox_id)
PRIMARY KEY (user_id, mailbox_id)
PRIMARY KEY(id)
PRIMARY KEY (message_idnr)
PRIMARY KEY (messageblk_idnr)
PRIMARY KEY (user_idnr)
PRIMARY KEY (user_idnr)
PRIMARY KEY (idnr)
-sc
--
Sean Chittenden
