Re: Using PL/pgSQL

On Mon, Nov 13, 2006 at 01:26:08PM -0800, Kojak wrote:
> I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm
> using PostGres 6.5.x (I know I need to upgrade...but that is another
> subject...).

No, you need to upgrade first. 6.5 is positivly prehistoric, no-one is
going to be much help dealing with something that old. It will leak
memory and other bizarre errors like that.

That said:

> ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: dlopen
> '/usr/local/pgsql/lib/plpgsql.so' failed. (Shared object"libpq.so.2"
> not found)
>
> I have verified that these 2 files do exist in the
> /usr/local/pgsql/lib/ directory. Their permissions are both rw-r--r--
> and owned by pgsql:pgsql

Maybe that directory is not in the search path? In any case, plpgsql
should not be using that library anyway, so there is something very odd
with your installation.

Perhaps you should upgrade.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.