Postgres Pro
Downloads
Home   >   mailing lists

Thread: plpgsql error?

plpgsql error?

From
s_marie@ekno.com (Sarah)
Date:
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.

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

Re: plpgsql error?

From
Jan Wieck
Date:
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@Yahoo.com #