[thelist] Constraint/trigger help

r937 rudy at r937.com
Fri May 18 10:17:31 CDT 2007


> How can I ensure (in the database) that default_mailbox
> references a mailbox that has its owner set to the same user?

probably with a CHECK constraint, if at all

the exact syntax depends on which database system you happen to be using --  
postgresql, sybase, db2, whatever

you'd be wise to put the necessary controls into your application logic as 
well, in case it's not possible to define it in the database

rudy
http://r937.com/ 





More information about the thelist mailing list