Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

Next:From: William WestDate: 2002-09-25 20:35:28
Subject: Meaning of/ handling of ECPG_NOTICE_* ??
Previous:From: Emilio RecioDate: 2002-09-25 13:57:28
Subject: Re: Cannot Statically Link libpq.a

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group