ecpg help

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

Responses

Browse pgsql-interfaces by date

  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