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