   Do we have a way, at the moment, supported or otherwise, to "share"
tables across multiple databases?  For instance, some of the catalogs
are the same from one database to another, but could I create a new
table and share it (and possibly some indexes on it) between more than
one database?
   Thanks in advance...

-Brandon :)

Sun, 15 Feb 1998 04:01:23 -0600 (CST)
Brandon Ibach <bibach@infomansol.com>
Shared tables
>    Do we have a way, at the moment, supported or otherwise, to "share"
> tables across multiple databases?  For instance, some of the catalogs
> are the same from one database to another, but could I create a new
> table and share it (and possibly some indexes on it) between more than
> one database?

No, that is not directly supported by the backend. You might be able to
do some trickery using soft links...

Also, I've been thinking about what it would take to allow the backend to
connect to another backend as a client. 'Course, I don't know much about
it, but it would be neat to be able to do...

                                                         - Tom


Sun, 15 Feb 1998 15:02:22 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] Shared tables
Thomas G. Lockhart said:
> 
> >    Do we have a way, at the moment, supported or otherwise, to "share"
> > tables across multiple databases?  For instance, some of the catalogs
> > are the same from one database to another, but could I create a new
> > table and share it (and possibly some indexes on it) between more than
> > one database?
> 
> No, that is not directly supported by the backend. You might be able to
> do some trickery using soft links...
> 
> Also, I've been thinking about what it would take to allow the backend to
> connect to another backend as a client. 'Course, I don't know much about
> it, but it would be neat to be able to do...
> 
   Sounds interesting... :)  As for table sharing, I could do hard or
soft links, but the question is, would that create the potential for
Postgres corrupting things, given that it isn't wise to the situation,
and could therefore defeat its own locking mechanisms?  Of course,
this would probably just be a read-only table (just some data I'd like
to have access to from multiple databases), so I could probably get
away with just creating the links.  Anybody have a reason against
this?

-Brandon :)

Tue, 17 Feb 1998 04:02:05 -0600 (CST)
Brandon Ibach <bibach@infomansol.com>
Re: [HACKERS] Shared tables