Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh' - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'
Date
Msg-id 199802232017.PAA06030@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'  (The Hermit Hacker <scrappy@hub.org>)
Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
>
> >
> > >
> > > 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.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] pg_user "sealed"
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Views on aggregates - need assistence