Postgres Pro
Downloads
Home   >   mailing lists

Thread: pbs with pg_dump

pbs with pg_dump

From
Jeff Anto
Date:
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


This kind of error came when I upgrade from 7.1.2 to
7.1.3. Before that, pg_dump used to work perfectly
well...

I also cheked pg_dump for very simple db (under
7.1.3), and it works fine...

I work with SUSE Linux, and any hints to *easily*
upgrade to 7.2 are welcome too...

Regards,
Jeff.

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

Re: pbs with pg_dump

From
Tom Lane
Date:
=?iso-8859-1?q?Jeff=20Anto?= <antojf2001@yahoo.fr> writes:
> Does anybody have ideas about the following ?

> Explanation from backend: ERROR:  Function OID 1258
> does not exist

Hmm.  Something bad has happened to your pg_proc entry for textcat().
Do you get anything if you do "select * from pg_proc where proname =
'textcat'" ?

            regards, tom lane

Re: pbs with pg_dump

From
Stephan Szabo
Date:
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.