Skip site navigation (1) Skip section navigation (2)

Re: procedural languages and public schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Francesco Dalla Ca'" <f(dot)dallaca(at)cineca(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: procedural languages and public schema
Date: 2005-07-13 14:20:23
Message-ID: 27837.1121264423@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Francesco Dalla Ca'" <f(dot)dallaca(at)cineca(dot)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

In response to

pgsql-admin by date

Next:From: Chris HooverDate: 2005-07-13 15:42:48
Subject: 7.3 and user permissions
Previous:From: Francesco Dalla Ca'Date: 2005-07-13 12:16:23
Subject: procedural languages and public schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group