Re: Beta2 - A Late Announcement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Beta2 - A Late Announcement
Date: 2002-09-30 14:57:00
Message-ID: 21290.1033397820@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce pgsql-general

Adam Witney <awitney(at)sghms(dot)ac(dot)uk> 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 :-(

regards, tom lane

In response to

Responses

Browse pgsql-announce by date

  From Date Subject
Next Message Adam Witney 2002-09-30 15:08:29 Re: Beta2 - A Late Announcement
Previous Message Adam Witney 2002-09-30 14:41:09 Re: Beta2 - A Late Announcement

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-09-30 15:02:17 Re: current_timestamp after queries
Previous Message Tom Lane 2002-09-30 14:42:08 Re: [SQL] arrays