Re: DROP ROLE dependency tracking ...

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DROP ROLE dependency tracking ...
Date: 2008-12-16 16:54:46
Message-ID: 200812161654.mBGGsk217955@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Added to TODO:

Allow dropping of a role that has connection rights

* http://archives.postgresql.org/pgsql-hackers/2008-05/msg00736.php

---------------------------------------------------------------------------

Hans-Juergen Schoenig wrote:
> good morning,
>
> some days ago i have fallen over an issue which feels more or less like
> a bug. consider:
>
>
> test=# create role xy LOGIN;
> CREATE ROLE
>
> test=# grant connect on database test to xy;
> GRANT
>
> test=# drop role xy;
> ERROR: role "xy" cannot be dropped because some objects depend on it
> DETAIL: access to database test
>
> this is a totally fresh instance --- all i did was creating a db called
> "test".
> failing would make sense if i would the owner of an object but i fact i
> don't own anything.
>
> test=# SELECT version();
>
> version
> ----------------------------------------------------------------------------------------------------------
> PostgreSQL 8.4devel on x86_64-unknown-linux-gnu, compiled by GCC gcc
> (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7)
> (1 row)
>
> is this a known issue?
>
> many thanks,
>
> hans
>
>
> --
> Cybertec Sch?nig & Sch?nig GmbH
> PostgreSQL Solutions and Support
> Gr?hrm?hlgasse 26, A-2700 Wiener Neustadt
> Tel: +43/1/205 10 35 / 340
> www.postgresql-support.de, www.postgresql-support.com
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Grzegorz Jaskiewicz 2008-12-16 17:17:02 Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1
Previous Message Pavel Stehule 2008-12-16 16:37:21 Re: Function with defval returns error