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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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