Re: createlang and Schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ian Harding" <ianh(at)tpchd(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: createlang and Schemas
Date: 2003-01-23 17:51:59
Message-ID: 26951.1043344319@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ian Harding" <ianh(at)tpchd(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-23 17:58:51 Re: Pg 7.3.1 & DBD::Pg 1.21
Previous Message will trillich 2003-01-23 17:48:27 Re: HOW-TO do incomplete dates: year, optional month, optional day?