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 [EMAIL PROTECTED] (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..." %%%% <[EMAIL PROTECTED]> % Getting To The Point', *Balance of Power*, ELO http://home.earthlink.net/~yatescr ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
