Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread Tom Lane
lindebg writes: > On 11/19/2011 04:34 AM, Tom Lane wrote: >> Color me skeptical. Under what conceivable use-case could you have >> functions that were mutually dependent in that way? And actually did >> something useful (not recurse till stack overflow) when called? > Does this mean that this s

Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread lindebg
On 11/19/2011 04:34 AM, Tom Lane wrote: Color me skeptical. Under what conceivable use-case could you have functions that were mutually dependent in that way? And actually did something useful (not recurse till stack overflow) when called? regards, tom lane Does this

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 #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread Tom Lane
lindebg writes: > On 11/19/2011 12:19 AM, lind...@gmail.com wrote: >>> Thanks, in this case works :-) However, this does not solve all cases. >>> Unlikely, but possible to create, cyclic case can not be restored: Color me skeptical. Under what conceivable use-case could you have functions that w

Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-19 Thread lindebg
On 11/19/2011 12:19 AM, lind...@gmail.com wrote: > Thanks, in this case works :-) However, this does not solve all cases. > Unlikely, but possible to create, cyclic case can not be restored: > Another example with more functions: $ psql create database test; \connect test create function fn1