public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alvaro Herrera <[email protected]>
To: Tom Lane <[email protected]>
Cc: Daniel Gustafsson <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: The word "virgin" used incorrectly and probably better off replaced
Date: Fri, 8 Nov 2019 12:08:52 -0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

On 2019-Nov-08, Tom Lane wrote:

> Alvaro Herrera <[email protected]> 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

view thread (18+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: The word "virgin" used incorrectly and probably better off replaced
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox