public inbox for [email protected]
help / color / mirror / Atom feedmark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?)
4+ messages / 3 participants
[nested] [flat]
* mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?)
@ 2006-01-04 14:45 Jaime Casanova <[email protected]>
2006-01-04 15:46 ` Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Tom Lane <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Jaime Casanova @ 2006-01-04 14:45 UTC (permalink / raw)
To: pgsql-docs
On 1/3/06, pres <[email protected]> wrote:
> hello tom,
>
>
> > See also the documentation on the system catalogs:
> > http://www.postgresql.org/docs/8.1/static/catalogs.html
> > The description of each catalog takes care to mention it if the catalog
> > is shared across databases.
> >
> > regards, tom lane
> >
>
>
> i'm not yet sure if/where we can make enduser requests, but in reading the
> documentation's "System Catalogs" section you'd pointed me to, i, of course,
> find:
>
>
>
> "... A few catalogs are physically shared across all databases in a cluster;
> these are noted in the descriptions of the individual catalogs.
>
> Table 42-1. System Catalogs..."
>
> i would find it helpful if Table 42-1 included a column that identified
> whehter each catalog is shared or not. convenient, but given that the
> documentation does contain it, not necessary.
>
> simply, it would be nice to see it as an overview.
>
> thank you again.
>
> pres
is this acceptable or usefull? if so, i can do it after work...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?)
2006-01-04 14:45 mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Jaime Casanova <[email protected]>
@ 2006-01-04 15:46 ` Tom Lane <[email protected]>
2006-01-04 16:08 ` Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database Bruce Momjian <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2006-01-04 15:46 UTC (permalink / raw)
To: Jaime Casanova <[email protected]>; +Cc: pgsql-docs
Jaime Casanova <[email protected]> writes:
> On 1/3/06, pres <[email protected]> wrote:
>> i would find it helpful if Table 42-1 included a column that identified
>> whehter each catalog is shared or not. convenient, but given that the
>> documentation does contain it, not necessary.
> is this acceptable or usefull? if so, i can do it after work...
It seems like clutter to me. Whether a catalog is shared or not is not
necessarily the first thing you want to know about it.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database
2006-01-04 14:45 mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Jaime Casanova <[email protected]>
2006-01-04 15:46 ` Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Tom Lane <[email protected]>
@ 2006-01-04 16:08 ` Bruce Momjian <[email protected]>
2006-01-04 16:16 ` Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Tom Lane <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2006-01-04 16:08 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Jaime Casanova <[email protected]>; pgsql-docs
Tom Lane wrote:
> Jaime Casanova <[email protected]> writes:
> > On 1/3/06, pres <[email protected]> wrote:
> >> i would find it helpful if Table 42-1 included a column that identified
> >> whehter each catalog is shared or not. convenient, but given that the
> >> documentation does contain it, not necessary.
>
> > is this acceptable or usefull? if so, i can do it after work...
>
> It seems like clutter to me. Whether a catalog is shared or not is not
> necessarily the first thing you want to know about it.
I am thinking the table should be split into two, one for the global
tables, and another for the db-local tables. I don't think we make it
clear enough which tables are global.
--
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?)
2006-01-04 14:45 mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Jaime Casanova <[email protected]>
2006-01-04 15:46 ` Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Tom Lane <[email protected]>
2006-01-04 16:08 ` Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database Bruce Momjian <[email protected]>
@ 2006-01-04 16:16 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2006-01-04 16:16 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Jaime Casanova <[email protected]>; pgsql-docs
Bruce Momjian <[email protected]> writes:
> Tom Lane wrote:
>> It seems like clutter to me. Whether a catalog is shared or not is not
>> necessarily the first thing you want to know about it.
> I am thinking the table should be split into two, one for the global
> tables, and another for the db-local tables.
That's even worse, as it converts the distinction into something you
must know even to look up the table.
> I don't think we make it clear enough which tables are global.
I think the labels appearing in the per-catalog descriptions are plenty
clear.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-01-04 16:16 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-04 14:45 mark wath catalogs are shared - was:(Re: [NOVICE] which database to login to to create global users?) Jaime Casanova <[email protected]>
2006-01-04 15:46 ` Tom Lane <[email protected]>
2006-01-04 16:08 ` Re: mark wath catalogs are shared - was:(Re: [NOVICE] which database Bruce Momjian <[email protected]>
2006-01-04 16:16 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox