Re: Unhappy thoughts about pg_dump and objects inherited from template1

From: Mark Hollomon <mhh(at)mindspring(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unhappy thoughts about pg_dump and objects inherited from template1
Date: 2000-11-11 02:52:06
Message-ID: 00111021520600.11065@jupiter
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Friday 10 November 2000 11:39, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > When we implement schemas, then all objects belonging to the
> > DEFINITION_SCHEMA will not be dumped, all other objects will be. At
> > least I imagine that this might be something to work with.
>
> That's a thought, although it still doesn't cope with the issue of
> "what if I've altered a standard system object?" ... which is what
> I think Mark was getting at yesterday. I

Correct. I don't know why anyone would want to change the definition of
(say) int48eq, but if we are going to allow them to do so, we should be
careful to allow them to backup and restore such a change.

The template0 solution is at least better than what we have. And since I
have no other more brilliant suggestions, I would vote for it.
--
Mark Hollomon

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alfred Perlstein 2000-11-11 03:19:25 Re: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)
Previous Message Tatsuo Ishii 2000-11-11 02:38:21 RE: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)