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 :)