Re: Tables spanning db's in cluster

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Tables spanning db's in cluster
Дата
Msg-id 200311100327.hAA3RBH03704@candle.pha.pa.us
обсуждение исходный текст
Ответ на Tables spanning db's in cluster  ("William Harazim" <wharazim@fulcoinc.com>)
Ответы Re: Tables spanning db's in cluster  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: disk access measurment
Следующее
От: Alex
Дата:
Сообщение: Problem Deleting Referenced records