Date: Mon, 1 Jul 2013 12:20:21 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: "Wojciechowski, Robert (GE Transportation)" <wojo@ge.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: How was I able to drop a role even though objects depend
 on it?
Message-ID: <20130701162021.GE3757@eldon.alvh.no-ip.org>
References: 
 <59BF48FAC524384DA413D8F4F2E4BA6907D9A9DA@CINURCNA06.e2k.ad.ge.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
In-Reply-To: 
 <59BF48FAC524384DA413D8F4F2E4BA6907D9A9DA@CINURCNA06.e2k.ad.ge.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Wojciechowski, Robert (GE Transportation) wrote:
> I=E2=80=99ve noticed a weird situation on one of our development servers =
running PostgreSQL 9.1.3 where roles have been dropped even though objects =
depend on that user. I didn=E2=80=99t think that was possible due to the de=
pendency checks on DROP USER/ROLE. For example, there is a database that sh=
ows this connect grant to a user that was known as foo1_userA (oid 35623395=
47): 3562339547=3Dc/postgres This happened after a nightly database import =
script was run that takes in new clone databases from production. After the=
 script imports new databases another script runs that drop all users match=
ing a regex (/^foo1_user/ for example) to clear out stale users. This obvio=
usly should succeed dropping a user that does not have dependent objects an=
d should fail on users that do. For some this is not holding true. Is this =
a bug? Am I relying too much on DROP USER/ROLE? Any alternative approaches =
to clearing out users that do not have dependent objects or guidance on deb=
ugging this situation would be much appreciated! -- Robert

It sounds like a bug to me.  Can you provide a self-contained reproducer
of this?  It'd be useful to know what kind of objects (should have)
depended on that user, for instance.

--=20
=C3=81lvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin