DROP USER weirdness in 7.2.1

From: Daniel Kalchev <daniel(at)digsys(dot)bg>
To: pgsql-hackers(at)postgresql(dot)org
Subject: DROP USER weirdness in 7.2.1
Date: 2002-10-15 08:04:07
Message-ID: 200210150804.g9F848u16555@dcave.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have encountered unexpected behavior of DROP USER in 7.2.1.

One would normally expect, that when DROP USER someuser is issued, all
associated data structures will be readjusted, especially ownership and access
rights.

This however does not happen.

After droping an user, that had ownership of tables, pg_dump complains :

[...]
pg_dump: WARNING: owner of data type table_one appears to be invalid
pg_dump: WARNING: owner of table "some_seq" appears to be invalid
[...]

The access rights to those tables remain

database=# \z table_one
Access privileges for database "customer"
Table | Access privileges
-------------+------------------------------
table_one | {=,98=arwdRxt,maria=arwdRxt}
(1 row)

There is no way to remove rights of this 'user' 98 using REVOKE etc.

Perhaps full dump/reload will remove the rights, because that user will not be
found, but restore may fail due to the error conditions.

Any resolution for this?

Regards,
Daniel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paesold 2002-10-15 09:08:58 Re: Bug in PL/pgSQL GET DIAGNOSTICS?
Previous Message Bruce Momjian 2002-10-15 04:22:33 Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c