Re: createlang and Schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: createlang and Schemas
Дата
Msg-id 26951.1043344319@sss.pgh.pa.us
обсуждение исходный текст
Ответ на createlang and Schemas  ("Ian Harding" <ianh@tpchd.org>)
Ответы Re: createlang and Schemas  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: dev@archonet.com
Дата:
Сообщение: Re: I was spoiled by the MySQL timestamp field
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Pg 7.3.1 & DBD::Pg 1.21