Kyle Bateman wrote:
> Is it possible to defer the check on a primary key constraint (or a
> check constraint, for that matter). Here is an example that shows why
> it would be nice to be able to do so. We have a real-life scenario that
> is similar (but much more complex).
Not yet. Only the trigger based foreign key checks are deferrable in 7.0. We discovered the need for
deferrability of UNIQUE (what is what you want from the PK things) and other checks. Not sure up to now how we
coulddo it, but a known problem.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #