Re: pbs with pg_dump - Mailing list pgsql-general

From Stephan Szabo
Subject Re: pbs with pg_dump
Date
Msg-id 20020306102637.J8596-100000@megazone23.bigpanda.com
Whole thread Raw
In response to pbs with pg_dump  (Jeff Anto <antojf2001@yahoo.fr>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Masaru Sugawara
Date:
Subject: Re: help with getting index scan
Next
From: thiemo
Date:
Subject: Re: Compiling problems