Re: [GENERAL] createlang and Schemas

Started by Bruce Momjianabout 23 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

Added to TODO:

* Add schema option to createlang

---------------------------------------------------------------------------

Justin Clift wrote:

Bruce Momjian wrote:

Is this a TODO? Not sure.

Is this a mis-feature (not really a bug) that should be fixed in 7.3.2?

Regards and best wishes,

Justin Clift

---------------------------------------------------------------------------

Tom Lane wrote:

"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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073