From: Francesco Dalla Ca' <f.dallaca@cineca.it>
To: pgsql-admin@postgresql.org
Subject: procedural languages and public schema
Date: Wed, 13 Jul 2005 14:16:23 +0200 (MEST)
Message-ID: <42D50617.6010204@cineca.it> (raw)
What are the implications between the use of a pl language and the
public schema?
When i use createlang on a database without the public schema (dropped
for safety reason), createlang fail with the sequent error
...
postgres@pc-dba:~> createlang -d prova2 plpgsql --echo
SELECT oid FROM pg_language WHERE lanname = 'plpgsql';
SELECT oid FROM pg_proc WHERE proname = 'plpgsql_call_handler' AND
prorettype = 'pg_catalog.language_handler'::regtype AND pronargs = 0;
SELECT oid FROM pg_proc WHERE proname = 'plpgsql_validator' AND
proargtypes[0] = 'pg_catalog.oid'::regtype AND pronargs = 1;
CREATE FUNCTION "plpgsql_call_handler" () RETURNS language_handler AS
'$libdir/plpgsql' LANGUAGE C;
CREATE FUNCTION "plpgsql_validator" (oid) RETURNS void AS
'$libdir/plpgsql' LANGUAGE C;
CREATE TRUSTED LANGUAGE "plpgsql" HANDLER "plpgsql_call_handler"
VALIDATOR "plpgsql_validator";
createlang: language installation failed: ERROR: no schema has been
selected to create in
postgres@pc-dba:~>
...
If i recreate the public schema (as default) the createlang perform
without error.
The client 'createlang' attempt to create 2 functions on the public schema:
plxxx_call_handler
plxxx_validator
these function have got respectively null acl list, from pg_proc:
prova2=# select pg_proc.oid, proname, nspname, proacl from pg_proc,
pg_namespace where pg_namespace.nspname='public' and
pg_namespace.oid=pronamespace;
oid | proname | nspname | proacl
--------+----------------------+---------+--------
571455 | plpgsql_call_handler | public |
571456 | plpgsql_validator | public |
(2 rows)
prova2=#
Can i create languages functions on a different schema?
This schema must be accessible for all db user? With which privileges
(only usage)?
What's the mean of the proacl column for these functions relatively to
TRUSTED|UNTRUSTED create language clause?
===========================================
CINECA Via Magnanelli 6/3
40033 Casalecchio di Reno (Bologna)
Settore Gestione Sistemi
Francesco Dalla Ca'
Email f.dallaca@cineca.it
===========================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: f.dallaca@cineca.it
Subject: Re: procedural languages and public schema
In-Reply-To: <42D50617.6010204@cineca.it>
References: <42D50617.6010204@cineca.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox