Re: pg_dumpall Sets Roll default_tablespace Before Creating Tablespaces - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_dumpall Sets Roll default_tablespace Before Creating Tablespaces
Date
Msg-id 201110272102.p9RL2nW20092@momjian.us
Whole thread Raw
In response to Re: pg_dumpall Sets Roll default_tablespace Before Creating Tablespaces  (Florian Pflug <fgp@phlo.org>)
Responses Re: pg_dumpall Sets Roll default_tablespace Before Creating Tablespaces
List pgsql-hackers
Florian Pflug wrote:
> On Oct21, 2011, at 16:42 , Phil Sorber wrote:
> > If you did want to make them immutable, I also like Florian's idea of
> > a dependency graph. This would make the dumps less readable though.
> 
> Hm, I kinda reversed my opinion on that, though - i.e., I no longer think
> that the dependency graph idea has much merit. For two reasons
> 
> First, dependencies work on OIDs, not on names. Thus, for the dependency
> machinery to work for GUCs, they'd also need to store OIDs instead of
> names of referenced schema objects. (Otherwise you get into trouble if
> objects are renamed)
> 
> Which of course doesn't work, at least for roles, because roles are
> shared objects, but referenced objects might be database-local.
> (search_path, for example).

Is this a TODO?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: (PATCH) Adding CORRESPONDING (NULL error)
Next
From: Chris Redekop
Date:
Subject: Re: Hot Standby startup with overflowed snapshots