[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

Postgresql.


> 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