[GENERAL] Compiling/Loading C function

1998-07-22 Thread Konstantinos Vassiliadis
Hello I am desperately trying to use a type I have created. PostgreSQL runs under SunOS 4.1.x. I followed the documentation's example on this platform % cc -I$PGROOT/include -I$PGROOT/src/include -PIC -c phone.c gives too many errors in header files... Then, I used gcc (following docu

[GENERAL] Postgres superuser priviledges

1998-07-21 Thread Konstantinos Vassiliadis
Hi I am new to Postgres. I am trying to load a C function in Postgres under Red Hat Linux. I compile using gcc -I$PGROOT -I$PGROOT/include -I$PGROOT/src/include -c phone.c to produce the object file 'phone.o' Then I link using ld -Bdynamic -o phone.so phone.o -lc to produce the shared object 'p

[GENERAL] Forwarded mail....

1998-07-20 Thread Konstantinos Vassiliadis
Hi I sent this message to the SQL-related mailing but nobody has replied for three days now. Can anyone help? Kostas -- Forwarded message -- Date: Sat, 18 Jul 1998 14:14:28 +0100 (BST) From: Konstantinos Vassiliadis <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Hello, I ha

[GENERAL] ERROR stat failed on file

1998-07-16 Thread Konstantinos Vassiliadis
Hi, I created a datatype dealing with phone numbers just to test the particular Postgres facility. I compiled the source independently of Postgres and run it independently, too. Then, I registered the input and output functions with Postgres and created the type using CREATE FUNCTION and CREATE T

[GENERAL] Error: LOAD cannot open object file

1998-07-16 Thread Konstantinos Vassiliadis
Hi, I try to load an object file into the Postgres address space with the command load 'home/M97/vassilik/protein/phone.o' and get the following ERROR: LOAD: could not open file /home/M97/vassilik/protein/phone.o I think it is because I am not the "postgres" user and the documentation (Ch 10

[GENERAL] SET type

1998-07-14 Thread Konstantinos Vassiliadis
Hi Does anyone know how to define a table with the type SET ? I have done a \dT and the very first type is SET which is described as a set of tuples I have tried create table a (col1 SET(b)) where b is another table but gave error at or near "set" Kostas VAssiliadis

[GENERAL] Palloc library

1998-07-10 Thread Konstantinos Vassiliadis
Hi, I wrote a user-defined function and inside the source make use of palloc. Somebody from the novice mailing list told me that the "palloc" source is included in libpq and therefore I have included "libpq-fe.h" as the documentation says. The program compiled fine. However, today I read in the FA

[GENERAL] Defining 'C' functions in Postgres

1998-07-10 Thread Konstantinos Vassiliadis
Hello I am using Postgres for the first time. I tried to define a 'C' function in Postgres using the CREATE FUNCTION command but encountered the following: ERROR: Only users with Postgres superuser privilege are permitted to create a function in the 'C' language. Others may use the 'sql' lang