diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-01-25 21:14:31 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-01-25 21:14:49 -0500 |
| commit | ebfe20dc706bd3238a9bdf3b44cd8f82337e86a8 (patch) | |
| tree | 0e68e06941f1b17d5e617d1fb9132f99830509bf /doc/src | |
| parent | c9b75c5838feeae73dbae00bce9d8f650b80ba38 (diff) | |
Allow UNLISTEN in hot-standby mode.
Since LISTEN is (still) disallowed, UNLISTEN must be a no-op in a
hot-standby session, and so there's no harm in allowing it. This
change allows client code to not worry about whether it's connected
to a primary or standby server when performing session-state-reset
type activities. (Note that DISCARD ALL, which includes UNLISTEN,
was already allowed, making it inconsistent to reject UNLISTEN.)
Per discussion, back-patch to all supported versions.
Shay Rojansky, reviewed by Mi Tar
Discussion: https://postgr.es/m/CADT4RqCf2gA_TJtPAjnGzkC3ZiexfBZiLmA-mV66e4UyuVv8bA@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/high-availability.sgml | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index 4882b20828a..bbab7395a21 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -1767,6 +1767,11 @@ if (!triggered) Plugins and extensions - <command>LOAD</command> </para> </listitem> + <listitem> + <para> + <command>UNLISTEN</command> + </para> + </listitem> </itemizedlist> </para> @@ -1856,7 +1861,7 @@ if (!triggered) </listitem> <listitem> <para> - <command>LISTEN</command>, <command>UNLISTEN</command>, <command>NOTIFY</command> + <command>LISTEN</command>, <command>NOTIFY</command> </para> </listitem> </itemizedlist> @@ -1864,8 +1869,8 @@ if (!triggered) <para> In normal operation, <quote>read-only</quote> transactions are allowed to - use <command>LISTEN</command>, <command>UNLISTEN</command>, and - <command>NOTIFY</command>, so Hot Standby sessions operate under slightly tighter + use <command>LISTEN</command> and <command>NOTIFY</command>, + so Hot Standby sessions operate under slightly tighter restrictions than ordinary read-only sessions. It is possible that some of these restrictions might be loosened in a future release. </para> |