Tom Lane wrote: > "Clark C. Evans" <[EMAIL PROTECTED]> writes: > > It would be wonderful to be able to create comments > > on users and groups. In particular, I need a place > > to store the user's name. Yes, I could make a user > > table, but that seems overkill as all of the other > > aspects of a user are already in the metadata. > > This seems like a good idea, but I'd recommend leaving it as a TODO > until after we finish the planned revisions for SQL role support. > (Peter E. has made noises about working on that, but I dunno what > his timeframe for it is.) In particular, it's not clear that there > will still be a hard and fast separation between "users" and "groups" > after that happens, so it seems premature to wire such an assumption > into the syntax. > > Another small problem that would have to be faced is that users and > groups don't have OIDs. We could physically get away with a type-cheat > of storing their integer IDs into pg_description instead, but I'm worried > that would create issues of its own.
Another problem is that pg_description is per-database, while pg_user/group are global for all databases. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
