Re: [GENERAL] Problem creating a function - solved

2006-07-19 Thread Cornelia Boenigk
Hi Tom, Joe After compiling the C-source files # gcc -fpic -c bitvg.c # gcc -shared -o bitvg.so bitvg.o the pg_restore created the function. It is Suse 9.x and PG 8.1.4 Thanks Conni ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmast

Re: [GENERAL] Problem creating a function

2006-07-19 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Could it be an SELinux issue? I'd really expect the strerror result to be something about 'permission denied' rather than 'file not found', if that were the problem... regards, tom lane ---(end of broadcast)

Re: [GENERAL] Problem creating a function

2006-07-19 Thread Joe Conway
Cornelia Boenigk wrote: Hi Joe > Try: > su postgres > cd /home/database/pgdata/cobis/bitvg Succeeds, ls -la shows all files in that directory and can open them with less. Kind of odd, particularly given your reply to Tom's question in a nearby post. Could it be an SELinux issue? Jo

Re: [GENERAL] Problem creating a function

2006-07-19 Thread Cornelia Boenigk
Hi Tom > You should try "ldd" or local equivalent on bitvg.so to check > whether all its dependencies can be found. output: ldd /home/database/pgdata/cobis/bitvg/bitvg.so statically linked Regards Conni ---(end of broadcast)--- TIP 9: In

Re: [GENERAL] Problem creating a function

2006-07-19 Thread Cornelia Boenigk
Hi Joe > Try: > su postgres > cd /home/database/pgdata/cobis/bitvg Succeeds, ls -la shows all files in that directory and can open them with less. Regards Conni ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] Problem creating a function

2006-07-19 Thread Tom Lane
Cornelia Boenigk <[EMAIL PROTECTED]> writes: > in english: /home/database/pgdata/cobis/bitvg/bitvg.so: cannot open > shared object: file not found > The file does exist in the path /home/database/pgdata/cobis/bitvg/: The "file not found" might be coming from the dynamic loader trying to load som

Re: [GENERAL] Problem creating a function

2006-07-19 Thread Joe Conway
Cornelia Boenigk wrote: The file does exist in the path /home/database/pgdata/cobis/bitvg/: -rwxr-xr-x 1 root root 133 Jul 19 13:13 bitvg.c -rwxr-xr-x 1 root root 782 Jul 19 13:13 bitvg.o -rwxr-xr-x 1 root root 3198 Jul 19 13:13 bitvg.so What do I miss? Does the postgres user have acce

[GENERAL] Problem creating a function

2006-07-19 Thread Cornelia Boenigk
Hi all Trying to create a function I get the following: codex=# CREATE FUNCTION "bitvg" (integer,integer) RETURNS integer AS '/home/database/pgdata/cobis/bitvg/bitvg.so', 'bitvg' LANGUAGE 'C'; ERROR: could not load library "/home/database/pgdata/cobis/bitvg/bitvg.so": /home/database/pgdata/c