Hi Tom, I didn't change my mind about prefix. I have tried to do everything by the book.
[EMAIL PROTECTED] postgres]$ pg_config --pkglibdir /opt/postgres-7.4.1//lib Really weird. One thing I have thought of is, shouldn't there be an etc directory in /opt/postgres-7.4.1: [EMAIL PROTECTED] postgres]$ ll /opt/postgres-7.4.1/ total 24 drwxr-xr-x 2 postgres postgres 4096 Feb 2 18:28 bin drwxr-xr-x 3 postgres postgres 4096 Feb 2 18:01 doc drwxr-xr-x 5 postgres postgres 4096 Feb 2 18:02 include drwxr-xr-x 2 postgres postgres 4096 Feb 2 18:02 lib drwxr-xr-x 4 postgres postgres 4096 Feb 2 18:01 man drwxr-xr-x 2 postgres postgres 4096 Feb 2 18:27 share ? Thanks for your effort! Rgds /Thomas. -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 6:58 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" <[EMAIL PROTECTED]> writes: > for some reason - conversion_create.sql the $libdir is not defined. I tried > to print $libdir from bin/initdb, but this variable is empty. $libdir is not an environment variable, it's a notation specially recognized by CREATE FUNCTION. It should expand to the same directory printed by "pg_config --pkglibdir". You might check what that prints. The only other idea that comes to mind is that you changed your mind about the install prefix during the installation and didn't do a full rebuild. The PKGLIBDIR setting is hardwired into dfmgr.o at compile time and maybe it didn't get recompiled. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
