From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions |
Date: | 2019-08-14 19:15:42 |
Message-ID: | 29770.1565810142@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
>> Perhaps we could put some of these details into the Notes section of the
>> ALTER SYSTEM ref page. But I wonder how much of this is needed at all.
> I'd be alright with that too, but I'd be just as fine with even a README
> or something that we feel other hackers and external tool developers
> would be likely to find. I agree that all of this isn't something that
> your run-of-the-mill DBA needs to know, but they are things that I'm
> sure external tool authors will care about (including myself, David S,
> probably the other backup/restore tool maintainers, and at least the
> author of pg_conftool, presumably).
In hopes of moving this along, I've pushed Ian's last code change,
as there seems to be no real argument about that anymore.
As for the doc changes, how about the attached revision of what
I wrote previously? It gives some passing mention to what ALTER
SYSTEM will do, without belaboring it or going into things that
are really implementation details.
As an example of the sort of implementation detail that I *don't*
want to document, I invite you to experiment with the difference
between
ALTER SYSTEM SET TimeZone = 'America/New_York';
ALTER SYSTEM SET "TimeZone" = 'America/New_York';
regards, tom lane
Attachment | Content-Type | Size |
---|---|---|
doc-alter-system-better-2.patch | text/x-diff | 2.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2019-08-14 20:28:55 | Improve Assert output |
Previous Message | Alvaro Herrera | 2019-08-14 18:33:36 | Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter |