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

Re: TODO item: Allow more complex user/database default GUC settings

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TODO item: Allow more complex user/database default GUC settings
Date: 2009-10-03 11:31:10
Message-ID: CD63991E42BA76CFF61AC182@amenophis (view raw or flat)
Thread:
Lists: pgsql-hackers

--On 1. Oktober 2009 17:22:06 -0400 Alvaro Herrera 
<alvherre(at)commandprompt(dot)com> wrote:

>> - The patch as is has still some locking problems (AlterRoleSet()
>> has a XXX about that): I've managed to create dead entries for a
>> role or a database in pg_db_role_setting while altering and dropping
>> a role/database in two concurrent sessions.
>
> Yeah, I was playing with that too.  I think we need a few extra
> LockSharedObject calls, and not only in the new code :-(  (This troubles
> me in the case of databases, because we already grab a lock on it during
> connection establishing, so this could cause extra contention there.)

I have marked the patch as "Ready For Committer", so it can be taken by a 
committer to help to resolve the remaining locking issue. There seems no 
other issues left. If this is too hasty, i can set it back to whatever you 
think its appropriate.

-- 
Thanks

	Bernd

In response to

pgsql-hackers by date

Next:From: Ian SmallDate: 2009-10-03 14:38:12
Subject: fuzzystrmatch patch Alphagram based fuzzy string matching
Previous:From: Albe LaurenzDate: 2009-10-03 09:03:53
Subject: Re: Rejecting weak passwords

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