pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive help / color / mirror / Atom feed From: Jim Parker <hopeye@cfl.rr.com>
To: Gary Knopp <gknopp@netezza.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ecpg help
Date: Fri, 27 Sep 2002 08:54:24 -0400
Message-ID: <20020927085424.I334@shamrock.cfl.rr.com\000> (raw )
In-Reply-To: <amsq0e$1a6j$1@news.hub.org >
References: <amsq0e$1a6j$1@news.hub.org >
The only thing that catches my eye, is the lack of the statement
exec sql include sqlca
with the include files. I forget the exact reason, but it is needed
for the
ECPG preprocessor.
hope this helps.
cheers,
Jim Parker
On 2002.09.25 12:58 Gary Knopp wrote:
> 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
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
view thread (4+ messages) latest in thread
Message-ID: <20020927085424.I334@shamrock.cfl.rr.com\000>
Permalink: ../20020927085424.I334@shamrock.cfl.rr.com%5C000/
Also on: postgresql.org/message-id/20020927085424.I334@shamrock.cfl.rr.com\000
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hopeye@cfl.rr.com, gknopp@netezza.com
Subject: Re: ecpg help
In-Reply-To: <20020927085424.I334@shamrock.cfl.rr.com\000>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox