Odd Happening.
| От | malcontent |
|---|---|
| Тема | Odd Happening. |
| Дата | |
| Msg-id | 39BAA395.B7E6612@msgto.com обсуждение исходный текст |
| Список | pgsql-hackers |
I found out during a pgdump/restore that not all tables were being backed up. After some investigation I suspect that this was because the tables in question were not owned by anybody! I don't know how this happened perhaps a user that owned those tabled was dropped. Another odd thing was that some of the tables had read permission for a user named 99. There was no such user created that I know of (of course one of the other admins may have fiddled with it I don't know, nobody has taken credit for it). It seems to me the deletion of a user does not cascade to permissions and ownerships. I suggest that either dropping user ought to be disalloved at this point or the tables revert to being owned by the postgres user. I am looking forward to being able to change owners in a more straightforward matter. Thanks for listening.
В списке pgsql-hackers по дате отправления: