From: Michael Fuhr <mike@fuhr.org>
To: Vilinski Vladimir <vilinski@web.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: WHY transaction waits for another transaction?
Date: Sun, 19 Jun 2005 10:22:09 -0600
Message-ID: <20050619162209.GA19463@winnie.fuhr.org> (raw)
In-Reply-To: <20050619155811.GA18897@winnie.fuhr.org>
References: <141218891@web.de>
<20050619155811.GA18897@winnie.fuhr.org>
On Sun, Jun 19, 2005 at 09:58:11AM -0600, Michael Fuhr wrote:
>
> If possible, it would be best to commit transactions that insert
> or update foreign keys as soon as possible.
I probably shouldn't have said "best" here, implying that this
solution is better than all other possibilities. As Tom Lane pointed
out, you could also make the constraints deferrable. If you don't
need to know about foreign key violations immediately, then deferring
the checks might be a better way to go.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
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: mike@fuhr.org, vilinski@web.de
Subject: Re: WHY transaction waits for another transaction?
In-Reply-To: <20050619162209.GA19463@winnie.fuhr.org>
* 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