From: | Andrew Kohlsmith <akohlsmith(at)mixdown(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: pg_dumpall forces plain text format |
Date: | 2002-07-11 14:18:19 |
Message-ID: | 200207111018.19778@-mixdown.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mats Lofkvist | 2002-07-11 15:29:12 | 7.2.1 backend crash (convert_string_datum, locale) |
Previous Message | Tom Lane | 2002-07-11 13:57:52 | Re: pg_dumpall forces plain text format |