Skip site navigation (1) Skip section navigation (2)

Re: Catalogs Doc update

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Catalogs Doc update
Date: 2002-10-11 12:05:58
Message-ID: 1034337959.297.22.camel@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
On Fri, 2002-10-11 at 00:19, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > - Mention that pg_database, pg_shadow, and pg_group are global, and the
> > rest are local to the specific DB. (I believe this is correct).
> This is already stated in the descriptions of those individual catalogs.
> I don't see the point of saying it redundantly elsewhere; that just adds
> another thing to have to maintain if we ever add more global catalogs.

How about the below then?  I've been asked by a couple of MSSQL experts
why they couldn't see all databases contents in the system catalogs.
There was also a docnote about this, so I think it's worth mentioning
they're local.

'Most of the system catalogs are copied during database creation from
the template database, as such are database specific.  Exceptions are
mentioned in the description of the individual catalog.'

  Rod Taylor

Attachment: catalog.patch
Description: text/x-patch (8.8 KB)

In response to


pgsql-patches by date

Next:From: Greg CopelandDate: 2002-10-11 13:30:55
Subject: Re: Peer to peer replication of Postgresql databases
Previous:From: Rod TaylorDate: 2002-10-11 11:56:14
Subject: Re: .cvsignore file

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group