Re: pg_dumpall forces plain text format

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

In response to

Browse pgsql-bugs by date

  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