From: | Keith Parks <emkxp01(at)mtcc(dot)demon(dot)co(dot)uk> |
---|---|
To: | maillist(at)candle(dot)pha(dot)pa(dot)us, jwieck(at)debis(dot)com |
Cc: | jwieck(at)debis(dot)com, lockhart(at)alumni(dot)caltech(dot)edu, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Rules for 6.4 finished |
Date: | 1998-08-26 15:43:33 |
Message-ID: | 199808261543.QAA00882@mtcc.demon.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
jwieck(at)debis(dot)com (Jan Wieck)
>
> > > Another topic is if we should create some more system views
> > > at initdb time. I would find views telling ownership and
> > > other information readable instead of Oid's very useful. As
> > > for pg_rule and pg_view it would be possible to create a view
> > > that describes the definition of an index instead of some
> > > cryptic numbers. And another one for real tables where
> > > indices and views are omitted would also be useful.
> >
> > Yes, these are good ideas.
> >
> > --
> > Bruce Momjian | 830 Blythe Avenue
>
> I'm running into some naming problems while doing so. Having
> pg_table, pg_view etc. as views lets a users assume pg_index
> would be one too where to get some information. But pg_index
> already exists.
>
> Should I name all of them pgv_... ?
>
> Other databases have many views starting with DBA or SYS on
> the other hand. For now I'll start naming them pgv_..., we
> could rename them before applying the patch.
>
Jan,
How about using the plural?
pg_views, pg_rules, pg_tables, pg_indexes etc...
It also seems more natural to me.
Keith.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-08-26 16:11:58 | Re: PostgreSQL under BSD/OS |
Previous Message | David Hartwig | 1998-08-26 15:12:25 | Re: [HACKERS] Rules for 6.4 finished |