Re: [GENERAL] Cannot drop user (PostgreSQL 8.1.11)

2008-06-03 Thread Ivan Zolotukhin
I recall I came across similar issue on older (8.1 or 8.2) versions of PostgreSQL some time ago. DB was pretty small so I dump-restored it eventually, but it looks like a bug anyway. I cannot reproduce it at 8.3. -- Regards, Ivan On Mon, Jun 2, 2008 at 7:12 PM, Maxim Boguk <[EMAIL PROTECTED]>

[GENERAL] Cannot drop user (PostgreSQL 8.1.11)

2008-06-02 Thread Maxim Boguk
I trying drop old user but got some strange issues: template1=# drop USER szhuchkov; ERROR: role "szhuchkov" cannot be dropped because some objects depend on it DETAIL: 1 objects in database billing 2 objects in database shop ok... lets look closer these two DB: shop=# drop USER szhuchkov; E