Re: The word "virgin" used incorrectly and probably better off replaced

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>, Bruce Momjian <bruce(at)momjian(dot)us>, brian(dot)williams(at)mayalane(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: The word "virgin" used incorrectly and probably better off replaced
Date: 2019-11-08 15:08:52
Message-ID: 20191108150852.GA32585@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 2019-Nov-08, Tom Lane wrote:

> Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> > Here's a proposed patch.
>
> I don't like this wording much, because "no user-defined objects"
> is not a sufficient specification of what we are talking about.
> You need to also capture the property that none of the system-
> defined objects have been altered. Now that we explicitly support
> things like altering the ACLs of system-defined objects, I do not
> think it's okay to take that part for granted.

Hmm. Maybe we can say "pristine database" and then add this explanation
in a parenthical comment:

This is particularly handy when restoring a
<literal>pg_dump</literal> dump: the dump script should be restored in a
pristine database (one where no user-defined objects exist and where
system objects have not been altered), to ensure that one recreates
the correct contents of the dumped database, without conflicting
with objects that might have been added to
<literal>template1</literal> later on.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2019-11-08 15:19:20 Re: The word "virgin" used incorrectly and probably better off replaced
Previous Message Tom Lane 2019-11-08 14:56:22 Re: The word "virgin" used incorrectly and probably better off replaced