Howto create a plperlu function as user (not superuser)??

From: Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Howto create a plperlu function as user (not superuser)??
Date: 2005-09-14 04:11:25
Message-ID: 20050914155152.W31901@storm-user.niwa.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a PostGIS enabled Postgres database. For institutional (un)reasons
I'm the database owner in all but reality.

I'm writing a plperl function to get the lat & lon coords from a geometry
and execute a system call to get the depth (or altitude) at a location
from a global datamodel.

So I and other users can do something like:
update site set depth = depth(todeg(site_geom));

(where site_geom is a point geometry. The todeg function is plpsql to
convert the point to lat long coords from any other projections, to match
the coordinate system of the global grid. It works fine.)

My problem is that the language needs to be plperlu (the unsecured
implementation of plperl) to be allowed to execute the system call to get
the depth at the specified location. To work, the plperlu function must be
created by the superuser, who I assume is postgres.

That is not me. Sigh. Is there any way I can develop (with the various
"create or replace function" iterations this wiil probably require) this
plperlu function as a non superuser?

Thanks,

Brent Wood

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-09-14 04:20:34 Re: MS SQL - PostgreSQL
Previous Message Joe 2005-09-14 04:09:58 Re: Partial dates