pbs with pg_dump
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
=?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
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.