Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: jwieck(at)debis(dot)com
Cc: scrappy(at)hub(dot)org, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [COMMITTERS] 'pgsql/src/bin/initdb initdb.sh'
Date: 1998-02-23 20:17:08
Message-ID: 199802232017.PAA06030@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1998-02-23 20:22:22 Re: [HACKERS] Views on aggregates - need assistence
Previous Message ocie 1998-02-23 20:15:11 Re: pl/{perl,pgsql} (was Re: AW: [HACKERS] triggers, views and ru