Re: Indication of db-shared tables

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Indication of db-shared tables
Date: 2011-06-22 13:10:02
Message-ID: 201106221310.p5MDA2j12820@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera wrote:
> Excerpts from Greg Sabino Mullane's message of mi jun 22 03:24:34 UTC 2011:
> >
> > Hash: RIPEMD160
> >
> > > Do we do enough to show which tables are db shared, e.g. pg_database? I
> > > don't see any indication from psql \dS. Are our docs clear enough?
> >
> > I don't think \dS should be indicating such a thing. I think it's documented
> > well enough: if you are doing something that it matters enough which
> > tables are shared, you really oughtta know about them anyway.
>
> Yeah. The user can't create new ones either, so why would it matter?

I assumed it was important to indicate if someone was looking at
per-database or per-cluster data, like pg_tablespace. The issue comes
up when I do admin training about the system tables.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-06-22 13:12:36 Re: [COMMITTERS] pgsql: Make the visibility map crash-safe.
Previous Message Bruce Momjian 2011-06-22 13:08:47 Re: WIP pgindent replacement