Re: Oracle Style packages on postgres

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Oracle Style packages on postgres
Дата
Msg-id 1115638427.4784.7.camel@fuji.krosing.net
обсуждение исходный текст
Ответ на Re: Oracle Style packages on postgres  (Thomas Hallgren <thhal@mailblocks.com>)
Список pgsql-hackers
On E, 2005-05-09 at 07:36 +0200, Thomas Hallgren wrote:
> Satoshi Nagayasu wrote:
> 
> >>    An oracle package is created when first referenced. Its initialization
> >>    code is run once (ie costly queries to populate session wide package
> >>    params) and the package dies at the end of the session
> >>    An analogy with OOP is that it's like having a single class instance
> >>    available for the duration of a session.
> >>
> PL/Java has an object called "Session" that does exactly this.

And pl/python has a global dictionary SD for the same purpose.

> It is not
> available from other languages at present. Are Packages supposed to be
> cross-language?

Probably not, as they already have most of the needed features.

Maybe we can set up some lighter version of package for cross-language
features (like installing removing a group of functions) but this are
much less needed for more advanced languages.

-- 
Hannu Krosing <hannu@skype.net>



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: test bed
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: How to make lazy VACUUM of one table run in several