Hi Tom, The make check worked fine (log attached).
ascii_and_mic.so lives i /opt/postgres-7.4.1/lib, and ldd yields: [EMAIL PROTECTED] lib]# ldd ascii_and_mic.so libc.so.6 => /lib/i686/libc.so.6 (0x42000000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) the complete contents of /opt/postgres-7.4.1/lib are: [EMAIL PROTECTED] postgres]$ ll /opt/postgres-7.4.1/lib/ total 4984 -rwxr-xr-x 1 postgres postgres 5759 Feb 2 18:01 ascii_and_mic.so -rwxr-xr-x 1 postgres postgres 13012 Feb 2 18:01 cyrillic_and_mic.so -rwxr-xr-x 1 postgres postgres 6065 Feb 2 18:01 euc_cn_and_mic.so -rwxr-xr-x 1 postgres postgres 11803 Feb 2 18:01 euc_jp_and_sjis.so -rwxr-xr-x 1 postgres postgres 6065 Feb 2 18:01 euc_kr_and_mic.so -rwxr-xr-x 1 postgres postgres 10632 Feb 2 18:01 euc_tw_and_big5.so -rwxr-xr-x 1 postgres postgres 7978 Feb 2 18:01 latin2_and_win1250.so -rwxr-xr-x 1 postgres postgres 7055 Feb 2 18:01 latin_and_mic.so -rw-r--r-- 1 postgres postgres 65352 Feb 2 18:02 libecpg.a -rw-r--r-- 1 postgres postgres 11470 Feb 2 18:02 libecpg_compat.a lrwxrwxrwx 1 postgres postgres 21 Feb 2 18:02 libecpg_compat.so -> libecpg_compat.so.1.1 lrwxrwxrwx 1 postgres postgres 21 Feb 2 18:02 libecpg_compat.so.1 -> libecpg_compat.so.1.1 -rwxr-xr-x 1 postgres postgres 18149 Feb 2 18:02 libecpg_compat.so.1.1 lrwxrwxrwx 1 postgres postgres 14 Feb 2 18:02 libecpg.so -> libecpg.so.4.1 lrwxrwxrwx 1 postgres postgres 14 Feb 2 18:02 libecpg.so.4 -> libecpg.so.4.1 -rwxr-xr-x 1 postgres postgres 55093 Feb 2 18:02 libecpg.so.4.1 -rw-r--r-- 1 postgres postgres 65710 Feb 2 18:02 libpgtypes.a lrwxrwxrwx 1 postgres postgres 17 Feb 2 18:02 libpgtypes.so -> libpgtypes.so.1.1 lrwxrwxrwx 1 postgres postgres 17 Feb 2 18:02 libpgtypes.so.1 -> libpgtypes.so.1.1 -rwxr-xr-x 1 postgres postgres 58224 Feb 2 18:02 libpgtypes.so.1.1 -rw-r--r-- 1 postgres postgres 123638 Feb 2 18:02 libpq.a lrwxrwxrwx 1 postgres postgres 12 Feb 2 18:02 libpq.so -> libpq.so.3.1 lrwxrwxrwx 1 postgres postgres 12 Feb 2 18:02 libpq.so.3 -> libpq.so.3.1 -rwxr-xr-x 1 postgres postgres 105391 Feb 2 18:02 libpq.so.3.1 -rwxr-xr-x 1 postgres postgres 1065390 Feb 2 18:02 plperl.so -rwxr-xr-x 1 postgres postgres 107331 Feb 2 18:02 plpgsql.so -rwxr-xr-x 1 postgres postgres 5780 Feb 2 18:01 utf8_and_ascii.so -rwxr-xr-x 1 postgres postgres 227051 Feb 2 18:01 utf8_and_big5.so -rwxr-xr-x 1 postgres postgres 14372 Feb 2 18:01 utf8_and_cyrillic.so -rwxr-xr-x 1 postgres postgres 125049 Feb 2 18:01 utf8_and_euc_cn.so -rwxr-xr-x 1 postgres postgres 218713 Feb 2 18:01 utf8_and_euc_jp.so -rwxr-xr-x 1 postgres postgres 137497 Feb 2 18:01 utf8_and_euc_kr.so -rwxr-xr-x 1 postgres postgres 338009 Feb 2 18:01 utf8_and_euc_tw.so -rwxr-xr-x 1 postgres postgres 1021504 Feb 2 18:01 utf8_and_gb18030.so -rwxr-xr-x 1 postgres postgres 354564 Feb 2 18:01 utf8_and_gbk.so -rwxr-xr-x 1 postgres postgres 6203 Feb 2 18:01 utf8_and_iso8859_1.so -rwxr-xr-x 1 postgres postgres 32683 Feb 2 18:01 utf8_and_iso8859.so -rwxr-xr-x 1 postgres postgres 280466 Feb 2 18:01 utf8_and_johab.so -rwxr-xr-x 1 postgres postgres 129195 Feb 2 18:01 utf8_and_sjis.so -rwxr-xr-x 1 postgres postgres 9707 Feb 2 18:01 utf8_and_tcvn.so -rwxr-xr-x 1 postgres postgres 280484 Feb 2 18:01 utf8_and_uhc.so -rwxr-xr-x 1 postgres postgres 9756 Feb 2 18:01 utf8_and_win1250.so -rwxr-xr-x 1 postgres postgres 9788 Feb 2 18:01 utf8_and_win1256.so -rwxr-xr-x 1 postgres postgres 9557 Feb 2 18:01 utf8_and_win874.so Best regards, Thomas. -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 4:38 PM To: [EMAIL PROTECTED] Cc: PostgreSQL Bugs List Subject: Re: [BUGS] BUG #1072: "$libdir/ascii_and_mic": No such file or directory "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > I have downloaded and built Postgres 7.4.1: > as user 'tbs': > ./configure --prefix=/opt/postgres-7.4.1/ --with-perl --enable-thread-safety > make > make check Did the "make check" work? > creating conversions... ERROR: could not access file > "$libdir/ascii_and_mic": No such file or directory What's in /opt/postgres-7.4.1/lib? If you see an ascii_and_mic.so there, what does ldd say about it? regards, tom lane
make_check.log
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match