Re: [PATCH] DefaultACLs

From: Petr Jelinek <pjmodos(at)pjmodos(dot)net>
To: Jan Urbański <wulczer(at)wulczer(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] DefaultACLs
Date: 2009-09-24 13:10:10
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Jan Urbański napsal(a):
> Dependencies suck, I know..

Cross-database dependencies do.

I had to make target role owner of the default acls which adds some side
effects like the fact that it blocks DROP ROLE so DROP OWNED BY has to
be used.
As for REASSIGN OWNED, it does not reassign anything (I don't think it's
a good idea to reassign default acls) it just spits warning with hint
what to do if user plans to drop the role.

Petr Jelinek (PJMODOS)

Attachment Content-Type Size
defacl-2009-09-24-2.diff.gz application/x-tar 18.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message ning 2009-09-24 13:17:12 Re: "BEGIN TRANSACTION" and "START TRANSACTION": different error handling
Previous Message daveg 2009-09-24 12:09:16 Re: "BEGIN TRANSACTION" and "START TRANSACTION": different error handling