From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Sarah <s_marie(at)ekno(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: plpgsql error? |
Date: | 2003-05-29 13:55:48 |
Message-ID: | 3ED61164.5020907@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sarah wrote:
> I am running postgres-7.2.1 on suse linux. I am not in a position to
> upgrade my version of postgres at this time. I have some plpgsql
> functions which are called from triggers. This worked fine in the
> past (with the current OS and this version of the database), but today
> my functions aren't working (ack!).
>
> I have the plpgsql.so in my LD_LIBRARY_PATH. I didn't have PGLIB set,
> but when I set it to point to the plpgsql.so directory, nothing
> changed.
Did you change that in the postmaster environment? It's the backend who
has to find the shared object file.
Jan
>
> I searched archives and found this error message related to createlang
> calls, but my createlang worked without error. I killed and restarted
> the postmaster to no avail.
>
> Is something obvious messed up in my environment? How can I debug
> this? I get this message when I delete from a table with a trigger
> that calls a plpgsql function:
>
>
>>delete from table1 where value = 'A5';
>>ERROR: stat failed on file '$libdir/plpgsql': No such file or directory
>
>
> Thanks in advance,
>
> Sarah
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Nick | 2003-05-29 14:03:23 | Error loading dynamic library |
Previous Message | Jan Wieck | 2003-05-29 13:52:14 | Re: How to deny user changing his own password? |