[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