plpgsql error?
От | s_marie@ekno.com (Sarah) |
---|---|
Тема | plpgsql error? |
Дата | |
Msg-id | 2fee7cc.0305191259.67abe994@posting.google.com обсуждение исходный текст |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: