Re: How to drop user if objects depend on it - Mailing list pgsql-general

From Andrus
Subject Re: How to drop user if objects depend on it
Date
Msg-id B8E81A0A8C9A4066AF62D7FE3DFCFD80@dell2
Whole thread Raw
In response to Re: How to drop user if objects depend on it  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to drop user if objects depend on it  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>The example script works for me.  What PG version are you running?  I have
>a vague recollection that we've fixed bugs-of-omission in DROP OWNED in
>the past.

I'm using

"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit"

In   "PostgreSQL 9.4.4, compiled by Visual C++ build 1800, 32-bit" it works.

It looks like in 9.1  reassign owned should replaced with revoke commands.

Andrus.



pgsql-general by date:

Previous
From: Steve Pribyl
Date:
Subject: Re: backup.old
Next
From: Paul Ramsey
Date:
Subject: PostGIS 2.2.0 Released