Re: plpgsql error?

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 #