Affects: 7.2.3 (possibly down to 7.1.0)
Frequency: Very Rare
Effect When Occurring: Database corruption
Difficulty of Fix: Trivial
Certianty of Diagnosis: about 50% according to Tom
This bug was analyzed by Tom Lane; I'm just writing it up.
In 7.2.3 (and possibly in earlier versions) these
PGBUGS£¬
Short Description
Drop user cannot delete the correspoding permission and cannot change the owner of
the namespace.
Long Description
When I droped a user, the all permission granted by other user cannot be deleted.
The all SQL statements show as the follow:
test=# CREATE user
