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
_
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
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
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
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
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