Re: restoreing dumps fail - Mailing list pgsql-general

From Tom Lane
Subject Re: restoreing dumps fail
Date
Msg-id 26357.1021390054@sss.pgh.pa.us
Whole thread Raw
In response to Re: restoreing dumps fail  (Martín Marqués <martin@bugs.unl.edu.ar>)
Responses Re: restoreing dumps fail
List pgsql-general
=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:
>> Hmm, that's bizarre.  How did you compile the array_iterator module?
>> There is no _fini routine in the source code, so this must be something
>> inserted by the compiler.

> Could it be, that the array_iterator was compiled with some old postgres-7.0.x
> and then was left there???

That's a good point.  Look at your dump script to see if it's trying to
do any CREATE FUNCTION commands with absolute paths to .so files.  If
so, you probably want to fix those to be $libdir-relative paths (a new
feature in 7.2, makes maintenance a lot easier).

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Quotes in SQL
Next
From: Andrew Sullivan
Date:
Subject: Re: transitioning postgres oid