Re: [ADMIN] Problem with triggers and functions

1999-08-02 Thread Callum Downie
I've had exactly same problem with PostgreSQL 6.4.x and 6.5.0 on Solaris 2.5.1 and 7 (latest GNU compilers and tools). Since I didn't have time to delve into code to find out why and not a priority, I installed RedHat 5.2 (then 6) on my Sun Sparc and PostgreSQL worked ok, compiling 6.4.2 and 6.5 f

Re: [ADMIN] Problem with triggers and functions

1999-08-02 Thread David Ouellet
It is a new install on Solaris 7. There is no file /etc/ld.so so following the instructions, I added /usr/local/pgsql/lib to my LD_LIBRARY_PATH. Terry Mackintosh wrote: > Hi David > > Is this a new install? on a Linux box? if so did you add > /usr/local/pgsql/lib to /etc/ld.so.conf and then run

[ADMIN] Problem with triggers and functions

1999-07-30 Thread David Ouellet
I'm having the following problem with functions and triggers (and it isn't an SQL problem.) With PostgreSQL version 6.4.2 when I try to use a function or trigger (either in C or plpgsql) I get the following message: ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: ld.so.1: /usr/local