Re: complex referential integrity constraints

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Joris Dobbelsteen <Joris(at)familiedobbelsteen(dot)nl>
Cc: Robert Haas <Robert(dot)Haas(at)dyntek(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: complex referential integrity constraints
Date: 2007-02-22 22:15:08
Message-ID: 20070222221508.GE31115@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 22, 2007 at 06:51:49PM +0100, Joris Dobbelsteen wrote:
> >Err, foreign keys are implemented using triggers, so this
> >statement is self-contradictary.
>
> Are you really sure they are executed under the same visibility rules?

Reasonably. I have no idea what visibility rules would make any
difference at all. AIUI a foreign key just takes a shared lock on the
referenced row and all the magic of MVCC makes sure the row exists when
the transaction completes.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Walker 2007-02-22 22:29:43 Re: postgresql vs mysql
Previous Message Stephan Szabo 2007-02-22 22:13:25 Re: complex referential integrity constraints