Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP USER results in backend closure - Mailing list pgsql-bugs

From Tom Lane
Subject Re: DROP USER results in backend closure
Date
Msg-id 22446.990889290@sss.pgh.pa.us
Whole thread Raw
In response to DROP USER results in backend closure  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> DROP USER results in backend closure

I followed your procedure and got:

regression=# DROP USER jmcaine;
ERROR:  DROP USER: user "jmcaine" owns database "test2", cannot be removed

AFAICT this has been the behavior at least since PG 7.0.

How old is that Debian package?

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: DROP USER results in backend closure
Next
From: Larry Rosenman
Date:
Subject: Compile Issue, current CVS/UnixWare 7.1.1