Skip site navigation (1) Skip section navigation (2)

Wrong FOR UPDATE lock type

From: Jan Wieck <janwieck(at)yahoo(dot)com>
To: PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org>
Subject: Wrong FOR UPDATE lock type
Date: 2000-12-04 12:52:50
Message-ID: 200012041252.HAA17027@jupiter.jw.home (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

    I'm  about  99.666667% sure that the lock type choosen in the
    FOR UPDATE case (line  511  of  parse_relation.c)  should  be
    RowExclusiveLock  instead  of  RowShareLock.   Actually I get
    "Deadlock risk" debug messages when selecting FOR UPDATE  and
    then really UPDATE.

    Should I change it?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck(at)Yahoo(dot)com #



Responses

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-12-04 12:55:53
Subject: Re: Using Threads?
Previous:From: Fabio NanniDate: 2000-12-04 12:39:34
Subject: triggers and actions tree

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group