Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8C562476179 for ; Wed, 25 Sep 2002 12:58:51 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 2BB7547611A for ; Wed, 25 Sep 2002 12:58:51 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id DFF86381808; Wed, 25 Sep 2002 12:58:54 -0400 (EDT) From: "Gary Knopp" X-Newsgroups: comp.databases.postgresql.interfaces Subject: ecpg help Date: Wed, 25 Sep 2002 12:58:55 -0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 103 Message-ID: X-Complaints-To: news@hub.org X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-interfaces@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/88 X-Sequence-Number: 3149 Hello, I'm running Postgresql 7.2.2 on RedHat Linux 7.1. I am trying to use Postgres embedded sql preprocessor (ECPG). However, I get a loading shared library problem when I attempt to execute a program. I included a simple example below... Thanks Error: ============ try: error while loading shared libraries: libecpg.so.3: cannot load shared object file: No such file or directory echo $LD_LIBRARY_PATH ====================== :/home/smith/lib:/usr/local/pgsql/lib:/usr/lib/qt/lib ls -l /usr/localpgsql/lib -rw-r--r-- 1 root root 46302 Aug 30 11:05 libecpg.a lrwxrwxrwx 1 root root 16 Aug 30 11:05 libecpg.so -> libecpg.so.3.3.0 lrwxrwxrwx 1 root root 16 Aug 30 11:05 libecpg.so.3 -> libecpg.so.3.3.0 -rwxr-xr-x 1 root root 40220 Aug 30 11:05 libecpg.so.3.3.0 -rw-r--r-- 1 root root 6664 Aug 30 11:05 libpgeasy.a lrwxrwxrwx 1 root root 16 Aug 30 11:05 libpgeasy.so -> libpgeasy.so.2.2 lrwxrwxrwx 1 root root 16 Aug 30 11:05 libpgeasy.so.2 -> libpgeasy.so.2.2 -rwxr-xr-x 1 root root 10809 Aug 30 11:05 libpgeasy.so.2.2 -rw-r--r-- 1 root root 30574 Aug 30 11:05 libpgtcl.a lrwxrwxrwx 1 root root 15 Aug 30 11:05 libpgtcl.so -> libpgtcl.so.2.2 lrwxrwxrwx 1 root root 15 Aug 30 11:05 libpgtcl.so.2 -> libpgtcl.so.2.2 -rwxr-xr-x 1 root root 35241 Aug 30 11:05 libpgtcl.so.2.2 -rw-r--r-- 1 root root 82598 Aug 30 11:05 libpq.a -rw-r--r-- 1 root root 68982 Aug 30 11:05 libpq++.a lrwxrwxrwx 1 root root 12 Aug 30 11:05 libpq.so -> libpq.so.2.2 lrwxrwxrwx 1 root root 14 Aug 30 11:05 libpq++.so -> libpq++.so.4.0 lrwxrwxrwx 1 root root 12 Aug 30 11:05 libpq.so.2 -> libpq.so.2.2 -rwxr-xr-x 1 root root 74685 Aug 30 11:05 libpq.so.2.2 lrwxrwxrwx 1 root root 14 Aug 30 11:05 libpq++.so.4 -> libpq++.so.4.0 -rwxr-xr-x 1 root root 47166 Aug 30 11:05 libpq++.so.4.0 -rwxr-xr-x 1 root root 1041877 Aug 30 11:05 plperl.so -rwxr-xr-x 1 root root 90075 Aug 30 11:05 plpgsql.so -rwxr-xr-x 1 root root 540450 Aug 30 11:05 plpython.so -rwxr-xr-x 1 root root 33726 Aug 30 11:05 pltcl.so ##################### try.pc ######################### #include EXEC SQL BEGIN DECLARE SECTION; int result; EXEC SQL END DECLARE SECTION; int main() { EXEC SQL CONNECT TO TmDB; EXEC SQL SELECT (1+1) INTO :result; printf("Result = %d\n",result); return 0; } ##################### Makefile####################### EC = ecpg CC = gcc INCPG = /usr/local/pgsql/include # Path for postgresql includes. #Declaration header. LIBPG = /usr/local/pgsql/lib # Path for ecpg libraries. LIBSPG = -lecpg -lpq # Ecpg libraries. CFLAGS = -Wall -g -c %.c: %.pc $(EC) -t -o $@ $< %.o: %.c $(CC) $(CFLAGS) -I $(INCPG) -o $@ $< all: try try: try.o $(CC) -o $@ $^ -L $(LIBPG) $(LIBSPG) clean: -rm -f *.o core