Re: [BUGS] Function will not back up on 7.2.3

2003-02-20 Thread Josh Berkus
Folks, This bug in 7.2.3 and 7.3.0 seems to have been fixed as a side effect of some of the other fixes in 7.2.4 and 7.3.2. We're not sure exactly *how*, but the bug occurs on 7.2.3 and not on 7.2.4. Did anybody do anything to patch dependancy tracking 7.2.3 ==> 7.2.4? -- -Josh Berkus _

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Josh Berkus
Tom, > Is it possible that the function's owner has been dropped from pg_shadow? No, the function owner is the database owner ... and also the same user calling pg_dump. > How about dropped return type, etc? pg_dump used to use inner joins to > collect info about database objects, meaning it

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> What do you mean by "refuses"? > The function is silently dropped from the pg_dump file. Is it possible that the function's owner has been dropped from pg_shadow? How about dropped return type, etc? pg_dump used to use inner joins to collect info about

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Josh Berkus
Tom, > > For some time, I've been noticing that one of my database projects fails to > > back up a few functions every time I run pg_dump.I've seen this since > > 7.1.3. Finally, I have a sample of the database that invariably refuses to > > back up one function. > > What do you m

Re: [BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > For some time, I've been noticing that one of my database projects fails to > back up a few functions every time I run pg_dump.I've seen this since > 7.1.3. Finally, I have a sample of the database that invariably refuses to > back up one function

[BUGS] Function will not back up on 7.2.3

2003-02-14 Thread Josh Berkus
Affects: 7.1.3, 7.2.1 to 7.2.3, not tested on 7.3.x or 7.4dev Frequency: 100% Reproducable Effect When Occurring: Object Missing from Backup Difficulty of Fix: Unknown For some time, I've been noticing that one of my database projects fails to back up a few functions every time I run pg_dump