Add prompt option to display read-only and read/write states in psql

Edit
ID 5872
Title Add prompt option to display read-only and read/write states in psql
CI (CFBot) Summary
Stats (from CFBot) Patch version: v10, Patch count: 1, First patch: +35−0, All patches: +35−0
Tags Good First Review psql
Created 2025-06-28 18:49:17
Last modified 2026-02-03 01:43:18 (5 days ago)
Latest email 2026-02-03 01:42:45 (5 days ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Committed
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-Drafts (2025-06-22 – 2026-02-28): Moved to different CF
Target version 19
Authors Jim Jones (jimus)
Reviewers Fujii Masao (masaofujii), Nathan Bossart (bossartn), Srinath Reddy (srinath-reddy-sadipiralla)Become reviewer
Committer Fujii Masao (masaofujii)
Links
Emails
display hot standby state in psql prompt
First at 2025-06-25 08:01:40 by Jim Jones <jim.jones at uni-muenster.de>
Latest at 2026-02-03 01:42:45 by Fujii Masao <masao.fujii at gmail.com>
Latest attachment (v10-0001-psql-Add-i-prompt-escape-to-indicate-hot-standby.patch) at 2026-01-30 02:00:29 from Fujii Masao <masao.fujii at gmail.com>
    Attachment (v10-0001-psql-Add-i-prompt-escape-to-indicate-hot-standby.patch) at 2026-01-30 02:00:29 from Fujii Masao <masao.fujii at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-i-prompt-escape-to-indicate-hot-standby-statu.patch) at 2026-01-27 14:43:04 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v8-0001-Add-i-prompt-escape-to-indicate-hot-standby-statu.patch) at 2026-01-27 08:36:54 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v7-0001-Add-i-prompt-escape-to-indicate-server-read-only-.patch) at 2025-10-31 21:00:51 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v6-0001-Add-i-prompt-escape-to-indicate-server-read-only-.patch) at 2025-10-30 10:16:53 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v5-0001-Add-i-prompt-escape-to-indicate-server-read-only-.patch) at 2025-10-27 08:08:17 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v4-0001-Add-i-prompt-escape-to-indicate-server-read-only-.patch) at 2025-10-24 20:31:41 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v3-0001-Add-i-prompt-escape-to-indicate-server-read-only-.patch) at 2025-07-23 08:03:54 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v2-0001-Add-i-prompt-escape-to-indicate-server-read-only-.patch) at 2025-07-22 09:51:49 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (v1-0001-Add-i-prompt-escape-to-indicate-server-read-only-.patch) at 2025-06-26 07:22:11 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
History
When Who What
2026-02-03 01:43:18 Fujii Masao (masaofujii) Closed in commitfest PG19-Final with status: Committed
2026-02-03 01:43:18 Fujii Masao (masaofujii) Changed committer to masaofujii
2026-02-01 00:00:08 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-29 07:59:13 Jim Jones (jimus) Changed tags to Good First Review, psql
2026-01-06 19:03:13 Jim Jones (jimus) Changed tags to Good First Review, psql
2025-12-01 08:16:19 Jim Jones (jimus) Moved from CF PG19-3 to CF PG19-4
2025-11-14 11:09:44 Fujii Masao (masaofujii) Added masaofujii as reviewer
2025-11-11 18:50:28 Nathan Bossart (bossartn) New status: Needs review
2025-10-23 21:02:54 Nathan Bossart (bossartn) Added bossartn as reviewer
2025-09-23 06:20:59 Jim Jones (jimus) Moved from CF PG19-2 to CF PG19-3
2025-07-24 00:45:26 Srinath Reddy (srinath-reddy-sadipiralla) New status: Ready for Committer
2025-07-23 07:07:13 Srinath Reddy (srinath-reddy-sadipiralla) Added srinath-reddy-sadipiralla as reviewer
2025-07-22 09:48:02 Jim Jones (jimus) Moved from CF PG19-Drafts to CF PG19-2
2025-06-28 18:49:17 Jim Jones (jimus) Attached mail thread 016f6738-f9a9-4e98-bb5a-e1e4b9591d46@uni-muenster.de
2025-06-28 18:49:17 Jim Jones (jimus) Created patch record
Edit