Re: Foreign key order evaluation

Mike,

I'm confused. Where is the lock? Is it on the 1 record in the model table?
If so, why is that record locked? Is it possible in Postgresql to update
the primary key of a record?

--RY

mike(at)fuhr(dot)org (Michael Fuhr) writes:

> On Mon, Sep 27, 2004 at 03:19:47PM -0400, Shawn Chisholm wrote:
>>
>> Hi, I am trying to deal with a deadlock situation caused by foreign
>> key references on insert and I was wondering if anyone knows what
>> order the foreign keys are locked (or evaluated) in for a particular
>> table? Deferring the locks is unfortunately not a good option for me...
>
> What do you mean by "what order the foreign keys are locked"? Can
> you give us an example of what you're doing and what problem you're
> trying to solve? As I mentioned in reply to your earlier message,
> foreign key locking and the potential for deadlock were recently
> brought up in pgsql-general:
>
> http://archives.postgresql.org/pgsql-general/2004-09/msg00405.php
> http://archives.postgresql.org/pgsql-general/2004-09/msg00442.php
>
> My followup to that thread (the second link above) mentions somebody
> else's suggestion for a shared lock on the foreign key, but as far
> as I can tell, no such solution has been implemented as of 8.0.0beta3.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
% Randy Yates % "And all that I can do
%% Fuquay-Varina, NC % is say I'm sorry,
%%% 919-577-9882 % that's the way it goes..."
%%%% <yates(at)ieee(dot)org> % Getting To The Point', *Balance of Power*, ELO
http://home.earthlink.net/~yatescr