From: | "Gary Knopp" <gknopp(at)netezza(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | ecpg help |
Date: | 2002-09-25 16:58:55 |
Message-ID: | amsq0e$1a6j$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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 <stdio.h>
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
From | Date | Subject | |
---|---|---|---|
Next Message | William West | 2002-09-25 20:35:28 | Meaning of/ handling of ECPG_NOTICE_* ?? |
Previous Message | Emilio Recio | 2002-09-25 13:57:28 | Re: Cannot Statically Link libpq.a |