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
