Package: postgresql-9.6 / 9.6.15-0+deb9u1

Metadata

Package Version Patches format
postgresql-9.6 9.6.15-0+deb9u1 3.0 (quilt)

Patch series

view the series file
Patch File delta Description
50 per version dirs.patch | (download)

src/Makefile.global.in | 4 2 + 2 - 0 !
src/bin/pg_config/pg_config.c | 8 3 + 5 - 0 !
2 files changed, 5 insertions(+), 7 deletions(-)

 use version specific installation directories so that several major versions can be installed in parallel.
51 default sockets in var.patch | (download)

src/include/pg_config_manual.h | 2 1 + 1 - 0 !
1 file changed, 1 insertion(+), 1 deletion(-)

 put server unix sockets into /var/run/postgresql/ by default
52 tutorial README.patch | (download)

src/tutorial/README | 3 1 + 2 - 0 !
1 file changed, 1 insertion(+), 2 deletions(-)

 update tutorial readme for required build dependencies.
53 pg_service.conf_directory_doc.patch | (download)

src/interfaces/libpq/pg_service.conf.sample | 4 2 + 2 - 0 !
1 file changed, 2 insertions(+), 2 deletions(-)

 update pg_service.conf example to tell the debian specific file location.
54 debian alternatives for external tools.patch | (download)

src/bin/psql/settings.h | 4 2 + 2 - 0 !
src/include/fe_utils/print.h | 2 1 + 1 - 0 !
2 files changed, 3 insertions(+), 3 deletions(-)

 use debian alternatives for external tools instead of hardcoded programs
64 pg_upgrade sockdir | (download)

src/bin/pg_upgrade/option.c | 5 5 + 0 - 0 !
1 file changed, 5 insertions(+)

---
70 history | (download)

HISTORY | 3 3 + 0 - 0 !
1 file changed, 3 insertions(+)

---
hurd sem_init | (download)

src/backend/Makefile | 4 4 + 0 - 0 !
src/template/linux | 7 7 + 0 - 0 !
2 files changed, 11 insertions(+)

---
filter debug prefix map | (download)

src/common/Makefile | 4 2 + 2 - 0 !
1 file changed, 2 insertions(+), 2 deletions(-)

---
client min messages | (download)

doc/src/sgml/config.sgml | 48 22 + 26 - 0 !
src/backend/utils/error/elog.c | 11 9 + 2 - 0 !
src/backend/utils/misc/guc.c | 19 2 + 17 - 0 !
src/backend/utils/misc/postgresql.conf.sample | 21 11 + 10 - 0 !
4 files changed, 44 insertions(+), 55 deletions(-)

 [patch] disallow setting client_min_messages higher than error.

Previously it was possible to set client_min_messages to FATAL or PANIC,
which had the effect of suppressing transmission of regular ERROR messages
to the client.  Perhaps that seemed like a useful option in the past, but
the trouble with it is that it breaks guarantees that are explicitly made
in our FE/BE protocol spec about how a query cycle can end.  While libpq
and psql manage to cope with the omission, that's mostly because they
are not very bright; client libraries that have more semantic knowledge
are likely to get confused.  Notably, pgODBC doesn't behave very sanely.
Let's fix this by getting rid of the ability to set client_min_messages
above ERROR.

In HEAD, just remove the FATAL and PANIC options from the set of allowed
enum values for client_min_messages.  (This change also affects
trace_recovery_messages, but that's OK since these aren't useful values
for that variable either.)

In the back branches, there was concern that rejecting these values might
break applications that are explicitly setting things that way.  I'm
pretty skeptical of that argument, but accommodate it by accepting these
values and then internally setting the variable to ERROR anyway.

In all branches, this allows a couple of tiny simplifications in the
logic in elog.c, so do that.

Also respond to the point that was made that client_min_messages has
exactly nothing to do with the server's logging behavior, and therefore
does not belong in the "When To Log" subsection of the documentation.
The "Statement Behavior" subsection is a better match, so move it there.

Jonah Harris and Tom Lane

Discussion: https://postgr.es/m/7809.1541521180@sss.pgh.pa.us
Discussion: https://postgr.es/m/15479-ef0f4cc2fd995ca2@postgresql.org