DROP ROLE dependency tracking ...
От | Hans-Juergen Schoenig |
---|---|
Тема | DROP ROLE dependency tracking ... |
Дата | |
Msg-id | 483904FC.5030906@cybertec.at обсуждение исходный текст |
Ответы |
Re: DROP ROLE dependency tracking ...
Re: DROP ROLE dependency tracking ... |
Список | pgsql-hackers |
good morning, some days ago i have fallen over an issue which feels more or less like a bug. consider: test=# create role xy LOGIN; CREATE ROLE test=# grant connect on database test to xy; GRANT test=# drop role xy; ERROR: role "xy" cannot be dropped because some objects depend on it DETAIL: access to database test this is a totally fresh instance --- all i did was creating a db called "test". failing would make sense if i would the owner of an object but i fact i don't own anything. test=# SELECT version(); version ----------------------------------------------------------------------------------------------------------PostgreSQL 8.4develon x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7) (1 row) is this a known issue? many thanks, hans -- Cybertec Schönig & Schönig GmbH PostgreSQL Solutions and Support Gröhrmühlgasse 26, A-2700 Wiener Neustadt Tel: +43/1/205 10 35 / 340 www.postgresql-support.de, www.postgresql-support.com
В списке pgsql-hackers по дате отправления: