Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory

Yes; you're right. Sorry. Meanwhile, I also discovered, my RedHat may
originally have put a competing postgres onto the system from some RPM.

[root(at)hubertus root]# rpm -q postgresql
postgresql-7.2.1-5

So now I've done:
[root(at)hubertus root]# rpm --erase postgresql postgresql-server
postgresql-contrib php-pgsql

After having done the "rpm --erase" I cleaned the /data/postgres and
/opt/postgres-7.4.1 directories; re-created the postgres user, but initdb
still had the same fault. So I re-inserted the "absolute path"-hack;
createdb, and started psql to create function. The result from strace (when
running the CREATE FUNCTION) of the backend is:

"Q\0\0\0\237CREATE OR REPLACE FUNCTION "..., 8192, 0) = 160
gettimeofday({1075756990, 462661}, NULL) = 0
stat64("/usr/local/pgsql/lib/ascii_and_mic", 0xbfffca10) = -1 ENOENT (No
such file or directory)
stat64("/usr/local/pgsql/lib/ascii_and_mic.so", 0xbfffca10) = -1 ENOENT (No
such file or directory)
stat64("$libdir/ascii_and_mic", 0xbfffcad0) = -1 ENOENT (No such file or
directory)
write(2, "ERROR: could not access file \"$"..., 81) = 81
send(8, "E\0\0\0\202SERROR\0C58P01\0Mcould not ac"..., 131, 0) = 131
rt_sigprocmask(SIG_SETMASK, ~[QUIT ILL TRAP ABRT BUS FPE KILL SEGV CONT STOP
SYS], NULL, 8) = 0
time(NULL) = 1075756990
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
send(8, "Z\0\0\0\5I", 6, 0) = 6
recv(8,

It seems to search in /usr/local/pgsql -- but that directory does not exist
(at least not after the rpm --erase).

Does this give you a clue ?

Rgds
/Thomas.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, February 02, 2004 9:52 PM
To: Thomas Borg Salling
Cc: 'PostgreSQL Bugs List'
Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or
directory

"Thomas Borg Salling" <tbs(at)navicon(dot)dk> writes:
> Does this give you any clues ?

That's what I expected, but it doesn't tell me anything new. Could you
try strace-ing the backend while you execute the CREATE FUNCTION
command?

regards, tom lane