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@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
