Re: [GENERAL] Postgres superuser priviledges

Konstantinos Vassiliadis wrote:
>
> 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 'phone.so'.
> (Assuming I am doing things right so far) Then from psql:
>
> => CREATE FUNCTION phone_in(opaque)
> RETURNS phone
> AS '/home/M97/acs/vassilik/protein/phone.so'
> LANGUAGE 'c';
> NOTICE: ProcedureCreate: type 'phone' is not yet defined
> CREATE
>
> Same for the output function, the type itself and a table that uses the
> type.
> Then
> test=> INSERT INTO test_phone VALUES ('01483-827294','0161-2242394');
> PQexec() -- Request was sent to backend, but backend closed the channel
> before responding.

There more than one thing that can go wrong. You are welcome to send me
your c source and sql to create the type. I will check.

> Can somebody help me? Anybody used Postgres under Linux Red Hat before?

That's how is used most often, I think. You could also try to build one
of my own extensions, found at

http://wit.mcs.anl.gov/~selkovjr/

ec-type.tgz is the easiest of these.

Gene