Re: How to drop user if objects depend on it

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Thom Brown" <thom(at)linux(dot)com>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to drop user if objects depend on it
Date: 2015-10-07 19:16:47
Message-ID: B8E81A0A8C9A4066AF62D7FE3DFCFD80@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ramsey 2015-10-07 19:25:37 PostGIS 2.2.0 Released
Previous Message Steve Pribyl 2015-10-07 19:16:13 Re: backup.old