Skip site navigation (1) Skip section navigation (2)

Re: pg_dumpall forces plain text format

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Kohlsmith <akohlsmith(at)mixdown(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dumpall forces plain text format
Date: 2002-07-11 13:57:52
Message-ID: 16602.1026395872@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Andrew Kohlsmith <akohlsmith(at)mixdown(dot)org> writes:
> Is there a way to start a transaction at the start of 
> the dump and hold it throughout successive connections, finally releasing it 
> at the end?

No, and since one backend can only talk to one database, I don't foresee
that changing.

> 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.

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.

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.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Andrew KohlsmithDate: 2002-07-11 14:18:19
Subject: Re: pg_dumpall forces plain text format
Previous:From: Andrew KohlsmithDate: 2002-07-11 13:43:20
Subject: Re: pg_dumpall forces plain text format

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group