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:
2009-08-11 22:19:21 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-08-26 02:17:38 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-18 20:03:27 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-09-21 02:56:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-21 04:21:43 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-21 15:08:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-21 16:23:44 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-21 16:24:59 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-21 23:44:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-23 18:10:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-23 19:03:27 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-09-23 19:27:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-21 11:42:21 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-09-21 22:46:53 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-09-22 03:31:14 from Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
2009-09-22 04:07:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-24 21:00:52 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-26 00:05:25 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-26 15:59:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-26 16:12:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-27 03:44:02 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-28 01:58:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-28 02:19:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-28 22:52:18 from decibel <decibel(at)decibel(dot)org>
2009-09-30 19:59:07 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-30 20:05:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-30 21:01:50 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-28 01:59:37 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-28 22:33:03 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-09-28 22:57:17 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-28 23:02:34 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-29 11:19:50 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-09-30 14:34:29 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-30 15:19:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-30 15:50:25 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-30 16:00:46 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-09-30 16:13:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-09-30 17:14:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-09-30 17:19:53 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-10-01 21:07:32 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-10-01 21:22:06 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-10-02 12:19:40 from Bernd Helmle <mailings(at)oopsware(dot)de>
2009-10-03 11:31:10 from Bernd Helmle <mailings(at)oopsware(dot)de>
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:12Subject : fuzzystrmatch patch Alphagram based fuzzy string matchingPrevious :From : Albe LaurenzDate : 2009-10-03 09:03:53Subject : Re: Rejecting weak passwords
