Thanks, quoting does indeed fix it. It's worth noting that comparing the
9.1 and 9.2 documentation, there is no hint that quoting/substitution
behavior changed. Or put another way, the docs say very little about
quoting/substitution behavior in general, aside from one highly confusing
"Note:" blo
nyet...@gmail.com writes:
> My psql PROMPT1, set through /etc/sysconfig/pgsql/psqlrc, is the following:
> h:%M%040d:%/%040U:%n%040AC:%:AUTOCOMMIT:%040TX:%x%012%R%#%040
You did not show us exactly how you set that, but I speculate that you
weren't bothering to quote it. 9.2 is more consistent than
The following bug has been logged on the website:
Bug reference: 8094
Logged by: Noah Yetter
Email address: nyet...@gmail.com
PostgreSQL version: 9.2.4
Operating system: Linux (Amazon AMI Linux x64, kernel 3.2.39)
Description:
My psql PROMPT1, set through /etc/sysconf