From: | malcontent <malcontent(at)msgto(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Odd Happening. |
Date: | 2000-09-09 20:54:45 |
Message-ID: | 39BAA395.B7E6612@msgto.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 2000-09-10 00:09:03 | Re: missing file relfilenode.h |
Previous Message | Tom Samplonius | 2000-09-09 20:25:22 | Re: Scalability, Clustering |