Re: Tables spanning db's in cluster - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Tables spanning db's in cluster
Date
Msg-id 200311100327.hAA3RBH03704@candle.pha.pa.us
Whole thread Raw
In response to Tables spanning db's in cluster  ("William Harazim" <wharazim@fulcoinc.com>)
Responses Re: Tables spanning db's in cluster  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
William Harazim wrote:
> Is it possible to define a table that spans all db's in a cluster
> similar to pg_database, pg_users?  Perhaps by altering relfilenode
> in pg_class of all db's to point to the same shared table...

Uh, no, I don't think that is possible.  You could try setting
pg_class.relisshared, but you would have to move the file over into the
/global directory --- not sure if that would work either, though.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: disk access measurment
Next
From: Alex
Date:
Subject: Problem Deleting Referenced records