Re: pbs with pg_dump

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jeff Anto <antojf2001(at)yahoo(dot)fr>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pbs with pg_dump
Date: 2002-03-06 18:28:04
Message-ID: 20020306102637.J8596-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Holger Marzen 2002-03-06 18:29:45 PostgreSQL and LDAP
Previous Message Thomas T. Thai 2002-03-06 18:11:17 Re: help with getting index scan