Your egrep is erroneous.
egrep -i '(key|constraint|references)' create_tables.pgsql
PRIMARY KEY (alias_idnr)
PRIMARY KEY (user_idnr)
owner_idnr INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE,
PRIMARY KEY (mailbox_idnr)
user_id INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE,
mailbox_id INT8 REFERENCES dbmail_mailboxes(mailbox_idnr)
PRIMARY KEY (user_id, mailbox_id)
user_id INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE,
mailbox_id INT8 REFERENCES dbmail_mailboxes(mailbox_idnr)
PRIMARY KEY (user_id, mailbox_id)
PRIMARY KEY(id)
mailbox_idnr INT8 REFERENCES dbmail_mailboxes(mailbox_idnr)
physmessage_id INT8 REFERENCES dbmail_physmessage(id)
PRIMARY KEY (message_idnr)
physmessage_id INT8 REFERENCES dbmail_physmessage(id)
PRIMARY KEY (messageblk_idnr)
user_idnr INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE,
PRIMARY KEY (user_idnr)
user_idnr INT8 REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE,
PRIMARY KEY (user_idnr)
PRIMARY KEY (idnr)
Sean Chittenden wrote:
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
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
