| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Andrus" <kobruleht2(at)hot(dot)ee> |
| 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:45:26 |
| Message-ID: | 8808.1444247126@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Andrus" <kobruleht2(at)hot(dot)ee> writes:
>> 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"
Ah. I believe this is fixed in 9.1.7 and later. In prior versions DROP
OWNED neglects to revoke permissions on shared objects (databases,
tablespaces).
Considering that 9.1.x is up to 9.1.19 as of tomorrow, you really ought
to think about doing a minor-version upgrade. We don't put out bug fix
releases just for idle amusement.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Mead | 2015-10-07 19:46:28 | Re: backup.old |
| Previous Message | David G. Johnston | 2015-10-07 19:38:48 | Re: backup.old |