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

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

2011-11-19 Thread Tom Lane
lindebg lind...@gmail.com 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

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

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

2011-11-19 Thread Tom Lane
lindebg lind...@gmail.com 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

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

2011-11-17 Thread lindebg
The following bug has been logged online: Bug reference: 6299 Logged by: lindebg Email address: lind...@gmail.com PostgreSQL version: 9.0, 9.1 Operating system: Linux, Windows Description:pg_dump, pg_dumpall - Problem with the order of backup functions Details: 1.

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

2011-11-17 Thread Tom Lane
lindebg lind...@gmail.com writes: Description:pg_dump, pg_dumpall - Problem with the order of backup functions Yeah, this was reported last month --- CREATE FUNCTION neglects to mark the function with the default expression as dependent on the other one. It'll be fixed in the next set