Sorry if this double posts. My first attempt was stalled because I was
not a member of the list. So now I am.
I'm starting to experiment with writing some stored functions in C and
find it really handy. I have a simple C function that takes two
integers and returns the sum. This works fine. Now I want to create a
function that makes us of some embedded ECPG. So far I have failed at
my first attempt. Below are the steps and outputs of what I did. I
assume it's feasible to embedd ECPG in a Postgres Stored function
written in C?
My foo1.pcg file looks like this.
EXEC SQL CREATE TABLE foo1 (c1 integer NOT NULL, c2 varchar(50) NOT NULL);
1. I run ecpg foo1.pcg and this generates my foo1.c file. I get no
warnings or errors.
[postgres(at)PortJackson ~]$ ecpg foo1.pgc
2. I compile foo1.c and get some warnings. Are these warnings ok?
[postgres(at)PortJackson ~]$ gcc -g -fpic -c foo1.c
foo1.pgc: In function 'foo1':
foo1.pgc:14: warning: passing argument 5 of 'ECPGdo' makes integer
from pointer without a cast
foo1.pgc:14: warning: passing argument 7 of 'ECPGdo' makes pointer
from integer without a cast
3.I link foo1. With now warnings or errors.
[postgres(at)PortJackson ~]$ gcc -shared -o foo1.so foo1.o
4. I create a function in psql to call my new library. And get a could
not load library error for file libecpg.so.6. How do I fix this
dev=# CREATE OR REPLACE FUNCTION foo1(integer)
RETURNS integer AS
LANGUAGE 'c' VOLATILE STRICT
ERROR: could not load library "/usr/home/postgres/foo1.so": dlopen
(/usr/home/postgres/foo1.so) failed: Shared object "libecpg.so.6" not
found, required by "foo1.so"
I'm new to C functions and to ECPG. So mixing the two at this point
for me is probably asking for trouble. Any help would be much
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2009-02-24 01:47:28|
|Subject: Re: C Stored Function with ECPG |
|Previous:||From: Tom Lane||Date: 2009-02-03 00:43:46|
|Subject: Re: char columns, space padding, and the "like" operator |