public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Euler Taveira <[email protected]>
Cc: Jeff Janes <[email protected]>
Cc: [email protected]
Subject: Re: Add <caution> for ALTER TEXT SEARCH CONFIGURATION
Date: Mon, 25 Nov 2019 10:16:59 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHE3wggE-k5y2Gnu45soTi5vJsJY12zqVZ_-VwNPHxtsUgFMrA@mail.gmail.com>
References: <CAMkU=1wQ-t=7gVoWRv6+yik+yZ20dEEwGjCXumNpHEFKLtxfVg@mail.gmail.com>
	<CAHE3wggE-k5y2Gnu45soTi5vJsJY12zqVZ_-VwNPHxtsUgFMrA@mail.gmail.com>

Euler Taveira <[email protected]> writes:
> Em sex., 15 de nov. de 2019 às 16:10, Jeff Janes
> <[email protected]> escreveu:
>> If you alter one of the built-in text search configurations, the modifications to it will not get dumped by pg_dump, and thus won't get propagated by pg_upgrade leading to silent behavior changes in the new cluster (as well in any other type of restoration from pg_dump output)

This isn't really different from what happens if you alter any object
defined by initdb.   (There are limited exceptions now for GRANT/REVOKE,
but not for any other object property.)

> It was a bad design to allow changes in builtin text search objects.

I disagree.  It is reasonable to point out that if you do that,
propagating your changes to new databases is your problem.  But
the fact that you can mess with built-in objects has always been
seen as a feature not a bug, and I'm not willing to change that
approach, nor to start plastering random man pages with bright
yellow cautions against doing so.  Having the code itself issue
complaints is right out.

			regards, tom lane

view thread (3+ messages)

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]
  Subject: Re: Add <caution> for ALTER TEXT SEARCH CONFIGURATION
  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