On Mon, 23 Feb 1998, Bruce Momjian wrote:
> >
> > >
> > > >
> > > > Update of /usr/local/cvsroot/pgsql/src/bin/initdb
> > > > In directory hub.org:/tmp/cvs-serv23999/bin/initdb
> > > >
> > > > Modified Files:
> > > > initdb.sh
> > > > Log Message:
> > > >
> > > > Modify initdb.sh so that it makes pg_user readable through view db_user
> > > > Modify psql so that it uses db_user instead of pg_user
> > > > GRANT SELECT on pg_class
> > >
> > > I don't know if I like the new name db_user? What do other people
> > > think? I thought pg_user_no_pwd would be nice.
> >
> >
> > create view pg_users as ...
> > ERROR: Illegal class name: pg_users -- pg_ is reserved for system catalogs
>
> Oops, yep.
>
> I guess I just liked that the pg_ stuff was all system stuff. Do you
> get this error when creating it from postgres, as initdb does? That
> would be a solution. Worked here.
My thought was more splitting the difference between a system
table (pg_) vs system view (db_) *shrug* Okay, I was grasping here :)