Re: Function will not back up on 7.2.3 - Mailing list pgsql-bugs

From Josh Berkus
Subject Re: Function will not back up on 7.2.3
Date
Msg-id 200302141647.14654.josh@agliodbs.com
Whole thread Raw
In response to Re: Function will not back up on 7.2.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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=20
calling pg_dump.

> How about dropped return type, etc?  pg_dump used to use inner joins to
> collect info about database objects, meaning it would silently miss
> objects that were missing expected collateral objects.

Return type is TEXT, so I think that's OK too.   However,  this database do=
es=20
have some pretty complex dependancies.

I just tested.  This is still a bug in 7.3.0.   I will download and test 7.=
3.2=20
now.

--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function will not back up on 7.2.3
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #897: EXTRACT(EPOCH FROM column): Possible wrong output