[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


More information about the thelist mailing list