Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-19 Thread Tom Lane
Josh Kupershmidt writes: > It's possible that the next 9.1 point release (9.1.2) would contain > this fix, but I haven't verified this (the way to check would be to do > a git checkout of the 9_1_STABLE branch from git, and see if the fix > is present there). No, it's not in any stable branch. I

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-19 Thread Tom Lane
Josh Kupershmidt writes: > On Fri, Nov 18, 2011 at 1:12 PM, M wrote: >> When psql expands a :variable into a string it appends a space to the >> expansion string. It doesn't actually do that, but rather splits the argument into two arguments. \echo makes it look like there's spaces between argu

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-18 Thread Josh Kupershmidt
On Sat, Nov 19, 2011 at 12:34 AM, Michael Smolsky > Now waiting for 9.2 package to ship for Ubuntu... Oh - 9.2 won't be released for a while; I tested on a recent git checkout of the main branch. It's possible that the next 9.1 point release (9.1.2) would contain this fix, but I haven't verified

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-18 Thread Josh Kupershmidt
On Fri, Nov 18, 2011 at 4:53 PM, Michael Smolsky wrote: > Could you please also confirm that variable expansion works correctly for > psql's \i command as well? > > Test case (type on psql client prompt): > > \set my_dir /some/path/to/sql/script/dir > \i :my_dir/my-script.sql > > I expect the pars

Re: [BUGS] BUG #6301: extra space in psql variable expansion

2011-11-18 Thread Josh Kupershmidt
On Fri, Nov 18, 2011 at 1:12 PM, M wrote: > > When psql expands a :variable into a string it appends a space to the > expansion string. For example: > > psql (8.4.9) > Type "help" for help. > > testdb=> \set my_home /home/crazy > testdb=> \echo :my_home/my-script.sql > /home/crazy /my-script.sql >