Re: 'tuple concurrently updated' error for alter role ... set - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 'tuple concurrently updated' error for alter role ... set
Date
Msg-id 12194.1305241163@sss.pgh.pa.us
Whole thread Raw
In response to Re: 'tuple concurrently updated' error for alter role ... set  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: 'tuple concurrently updated' error for alter role ... set  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, May 12, 2011 at 6:28 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> We're not likely to do that, first because it's randomly different from
>> the handling of every other system catalog update,

> We have very robust locking of this type for table-related DDL
> operations and just about none for anything else.  I don't consider
> the latter to be a feature.

I didn't say it was ;-).  What I *am* saying is that if we're going to
do anything about this sort of problem, there needs to be a
well-considered system-wide plan.  Arbitrarily changing the locking
rules for individual operations is not going to make things better,
and taking exclusive locks on whole catalogs is definitely not going to
make things better.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: 'tuple concurrently updated' error for alter role ... set
Next
From: "Kevin Grittner"
Date:
Subject: Re: SSI-related code drift between index_getnext() and heap_hot_search_buffer()