Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de
	[53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id OAA86954
	for <pgsql-sql@postgreSQL.org>; Fri, 4 Feb 2000 14:55:37 -0500 (EST)
	(envelope-from wieck@debis.com)
Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org
	id m12Goeb-0003kbC; Fri, 4 Feb 100 20:44 MET
Message-Id: <m12Goeb-0003kbC@orion.SAPserv.Hamburg.dsh.de>
From: wieck@debis.com (Jan Wieck)
Subject: Re: [SQL] Concurrency problem
In-Reply-To: 
 <Pine.LNX.4.10.10002041330580.10954-100000@r149127-2815.dobiecenter.com>
	from Taral at "Feb 4, 2000 01:31:11 pm"
To: Taral <taral@taral.net>
Date: Fri, 4 Feb 2000 20:44:29 +0100 (CET)
CC: Jan Wieck <wieck@debis.com>, pgsql-sql@postgreSQL.org
Reply-To: Jan Wieck <wieck@debis.com>
X-Mailer: ELM [version 2.4ME+ PL68 (25)]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> On Fri, 4 Feb 2000, Jan Wieck wrote:
>
> >     You  cannot  use  a  regular trigger because of your circular
> >     dependency. What you really need to insure integrity  is  the
> >     FOREIGN  KEY  support  coming  with 7.0. It is implemented as
> >     triggers too, but they are handled a little different by  the
> >     trigger  manager  and  their  execution  can be delayed until
> >     COMMIT.
>
> Does the CVS version have this support?

    Mostly. Look at

        http://www.PostgreSQL.org/projects/

    to get a clue about the syntax. And follow the TODO link on

        http://www.PostgreSQL.org/~wieck/

    to see what we still need to fix/finish until BETA.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #