Re: Beta2 - A Late Announcement

On 30/9/02 3:57 pm, "Tom Lane"  wrote:

> Adam Witney  writes:
>> Ahh yes, it is failing just as it is trying to create the
>> plpgsql_call_handler ready for adding the PL/pgSQL language, which includes
>> a hard coded path to plpgsql.so
> 
>> If I manually changed the path to the newly complied plpgsql.so would that
>> be ok?
> 
> I'd recommend editing the dump to use path
> '$libdir/plpgsql'
> which is the preferred setup going forward --- it's
> installation-independent because the backend will automatically add
> the correct library-directory path and shared-library extension.
> 
> createlang has created languages this way since 7.2, but dumps loaded
> from prior releases probably still have hardcoded paths in them :-(


Yup, I just manually changed the path to the language library and those
errors disappeared.

This was dumped from 7.2.2 but the paths were hardcoded.

Thanks for your help

Adam


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.