[thelist] Constraint/trigger help

Bill Moseley moseley at hank.org
Fri May 18 13:09:21 CDT 2007

On Fri, May 18, 2007 at 11:17:31AM -0400, r937 wrote:
> > 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

Yes, of course.  But want the database to maintain correct application
state where possible.

Bill Moseley
moseley at hank.org

More information about the thelist mailing list