Re: [BUGS] BUG #8094: psql prompt variable and command substitution broken

2013-04-18 Thread Noah Yetter
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

Re: [BUGS] BUG #8094: psql prompt variable and command substitution broken

2013-04-18 Thread Tom Lane
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

[BUGS] BUG #8094: psql prompt variable and command substitution broken

2013-04-18 Thread nyetter
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