| 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 |
| Message-ID: | 4ABB6FB2.1000203@pjmodos.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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.
--
Regards
Petr Jelinek (PJMODOS)
| Attachment | Content-Type | Size |
|---|---|---|
| defacl-2009-09-24-2.diff.gz | application/x-tar | 18.2 KB |
| 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 |