Defining 'C' functions in Postgres

From: Konstantinos Vassiliadis <vassilik(at)p03(dot)cs(dot)man(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Defining 'C' functions in Postgres
Date: 1998-07-10 18:30:01
Message-ID: Pine.LNX.3.95.980710192600.15982D-100000@p03.cs.man.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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' language
or the created procedural languages.

The command is
CREATE FUNCTION phone_in(opaque)
RETURNS phone
AS '/home/M97/acs/vassilik/protein/phone.o'
LANGUAGE 'c';

It is not me that installed Postgres. Is this the problem?

Kostas Vassiliadis

Browse pgsql-general by date

  From Date Subject
Next Message Konstantinos Vassiliadis 1998-07-10 18:33:50 Palloc library
Previous Message Jackson, DeJuan 1998-07-10 17:22:29 RE: [GENERAL] Triggers: options besides compiled code?