| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | William Harazim <wharazim(at)fulcoinc(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tables spanning db's in cluster |
| Date: | 2003-11-10 03:27:11 |
| Message-ID: | 200311100327.hAA3RBH03704@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2003-11-10 04:38:28 | Re: Problem in restoring data [SOLVED ] |
| Previous Message | Bruce Momjian | 2003-11-10 03:23:43 | Re: disk access measurment |