Re: createlang and Schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: createlang and Schemas
Date
Msg-id 26951.1043344319@sss.pgh.pa.us
Whole thread Raw
In response to createlang and Schemas  ("Ian Harding" <ianh@tpchd.org>)
Responses Re: createlang and Schemas
List pgsql-general
"Ian Harding" <ianh@tpchd.org> writes:
> createlang seems not to take a schema argument.  Should it?

Hm.  The language itself does not have any associated schema --- but the
underlying call handler function does.  Perhaps there should be a way to
tell createlang which schema to put the function in.  Right now it will
be effectively determined by the default search path, so you could do

    PGOPTIONS='--search_path=myschema' createlang plpgsql mydb

but this seems inelegant.

            regards, tom lane

pgsql-general by date:

Previous
From: dev@archonet.com
Date:
Subject: Re: I was spoiled by the MySQL timestamp field
Next
From: Tom Lane
Date:
Subject: Re: Pg 7.3.1 & DBD::Pg 1.21