Re: Deferral of primary key constraint

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 could do 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(at)Yahoo(dot)com #