On Tue, Apr 22, 2014 at 3:39 PM, Igor Neyman wrote:
>
>
> From: pgsql-general-ow...@postgresql.org [mailto:
pgsql-general-ow...@postgresql.org] On Behalf Of Craig Libscomb
> Sent: Tuesday, April 22, 2014 4:27 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Can
On Tue, Apr 22, 2014 at 3:30 PM, Tom Lane wrote:
>
> Craig Libscomb writes:
> > The following command:
> > DROP USER IF EXISTS jpate;
>
> > generates the following output:
> > ERROR: role "jpate" cannot be dropped because some objects depend on it
On Tue, Apr 22, 2014 at 3:06 PM, Raymond O'Donnell wrote:
> On 22/04/2014 20:47, Craig Libscomb wrote:
> > The following command:
> > DROP USER IF EXISTS jpate;
> >
> > generates the following output:
> > ERROR: role "jpate" cannot be dropped
object_name
FROM
WHERE object_owner = 'jpate';
So I can see what jpate owns.
>
>
>
---- Original message
> From: Craig Libscomb
> Date:04-22-2014 15:47 (GMT-05:00)
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Can't delete role beca
The following command:
DROP USER IF EXISTS jpate;
generates the following output:
ERROR: role "jpate" cannot be dropped because some objects depend on it
DETAIL: 1 object in database products
It would be most helpful to know what object in the products database
depends on the jpate role, but I
