From: wieck@debis.com
To: Taral <taral@taral.net>
Cc: Jan Wieck <wieck@debis.com>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Concurrency problem
Date: Fri, 4 Feb 2000 20:44:29 +0100 (CET)
Message-ID: <m12Goeb-0003kbC@orion.SAPserv.Hamburg.dsh.de> (raw)
In-Reply-To: <Pine.LNX.4.10.10002041330580.10954-100000@r149127-2815.dobiecenter.com>
> 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) #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wieck@debis.com, taral@taral.net
Subject: Re: [SQL] Concurrency problem
In-Reply-To: <m12Goeb-0003kbC@orion.SAPserv.Hamburg.dsh.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox