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
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 #