> > Or is that on the TODO for whenever foreign keys can be across databases?
> I very seriously doubt that PG will *ever* support foreign keys across
> databases.
No problem. I'm not that advanced of a user or admin to want it, I was just
trying to peer into the crystal ball and try to anticipate future problems.
:-)
> The current development direction is not to improve communication across
> databases, but to support schemas and improve privilege checking so that
> users can more usefully be assigned separate schemas within a single
> database. I think that multiple databases in a cluster will eventually
> be used only for the cases where you *want* airtight separation between
> two collections of data.
Understood.
> Hence, I'm not particularly concerned by complaints about lack of
> cross-database functionality --- the folks who think they want that
> actually want cross-schema operations, which will work fine in 7.3.
Thank you for your time and comments. I feel a lot "safer" about these
backups now.
Regards,
Andrew