cb psql terminal goes fuzzy and breaks the REPL on PROMPT1

TL;DR

The fuzzy REPL was a rendering bug in cb psql 3.4.1, fixed in 3.5.1, so upgrading is the fix. I found that setting PROMPT1 to something simpler like \set PROMPT1 '(%n@%M:%>) %date +%H:%M:%S [%/] \n%x%# ' worked around it.

Steps

1. Running cb psql on version 3.4.1, the terminal went fuzzy and the REPL broke whenever the prompt rendered, classic PROMPT1 wrapping weirdness. I found that setting PROMPT1 to something simpler like \set PROMPT1 '(%n@%M:%>) %date +%H:%M:%S [%/] \n%x%# ' worked around it. The maintainer asked for the version and the reporter confirmed it was gone after updating to 3.5.1. Closed May 2024.
2. The fuzzy REPL was a rendering bug in cb psql 3.4.1, fixed in 3.5.1, so upgrading is the fix. If you need to stay on the old version, the workaround is to simplify your psql PROMPT1 so it renders on a single predictable line, the reporter used \set PROMPT1 '(%n@%M:%>) %date +%H:%M:%S [%/] \n%x%# '. The maintainer confirmed the fix landed and the reporter verified it worked after the update.

Expected: The maintainer confirmed the fix landed and the reporter verified it worked after the update.

When to use

You are seeing this: Running cb psql on version 3.4.1, the terminal went fuzzy and the REPL broke whenever the prompt rendered, classic PROMPT1 wrapping weirdness. Use this skill when you run into "cb psql terminal goes fuzzy and breaks the REPL on PROMPT1".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

Versions mentioned in the source: 3.4.1, 3.5.1. If you are on something much newer or older, the details may have shifted.

Why this happens

Running cb psql on version 3.4.1, the terminal went fuzzy and the REPL broke whenever the prompt rendered, classic PROMPT1 wrapping weirdness.

In the thread cb psql terminal goes fuzzy and breaks the REPL on PROMPT1, the question was: Running cb psql on version 3.4.1, the terminal went fuzzy and the REPL broke whenever the prompt rendered, classic PROMPT1 wrapping weirdness. I found that setting PROMPT1 to something simpler like \set PROMPT1 '(%n@%M:%>) %date +%H:%M:%S [%/] \n%x%# ' worked around it. The maintainer asked for the version and the reporter confirmed it was gone after updating to 3.5.1. Closed May 2024. The verified resolution: The fuzzy REPL was a rendering bug in cb psql 3.4.1, fixed in 3.5.1, so upgrading is the fix. If you need to stay on the old version, the workaround is to simplify your psql PROMPT1 so it renders on a single predictable line, the reporter used \set PROMPT1 '(%n@%M:%>) %date +%H:%M:%S [%/] \n%x%# '. The maintainer confirmed the fix landed and the reporter verified it worked after the update. Original discussion: https://vectle.com/threads/thrcyGhBBDnMWLJQ7-rAyiYQ