Re: pbs with pg_dump

On Wed, 6 Mar 2002, [iso-8859-1] Jeff Anto wrote:

> Hi all,
> Does anybody have ideas about the following ?
>
> $> pg_dump -v hn_test7 > test.pgdump
> --  saving database definition
> --  last builtin oid is 18539
> --  reading user-defined types
> --  reading user-defined functions
> --  reading user-defined aggregates
> --  reading user-defined operators
> --  reading user-defined tables
> --  finding Triggers for relation: 'language'
> --  finding Triggers for relation:
> 'languages_properties'
>
> getTables(): SELECT (for VIEW DEFINITION) failed.
> Explanation from backend: ERROR:  Function OID 1258
> does not exist

Sounds like you have a view that references a function
that doesn't exist any longer (perhaps you dropped and
recreated it?).  You probably just need to find which view
it is and drop it.