Re: procedural languages and public schema - Mailing list pgsql-admin

From Tom Lane
Subject Re: procedural languages and public schema
Date
Msg-id 27837.1121264423@sss.pgh.pa.us
Whole thread Raw
In response to procedural languages and public schema  (Francesco Dalla Ca' <f.dallaca@cineca.it>)
List pgsql-admin
"Francesco Dalla Ca'" <f.dallaca@cineca.it> writes:
> Can i create languages functions on a different schema?

You can, but you'd have to modify the createlang program, or do it by
hand using CREATE FUNCTION and CREATE LANGUAGE.  This is just a
restriction of createlang, not any fundamental limitation.

IIRC, we just changed things for 8.1 and up so that the functions are
created in pg_catalog instead of public.

            regards, tom lane

pgsql-admin by date:

Previous
From: Francesco Dalla Ca'
Date:
Subject: procedural languages and public schema
Next
From: Chris Hoover
Date:
Subject: 7.3 and user permissions