| From: | Hannu Krosing <hannu(at)skype(dot)net> |
|---|---|
| To: | Thomas Hallgren <thhal(at)mailblocks(dot)com> |
| Cc: | Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, "rmm(at)sqlisor(dot)com" <rmm(at)sqlisor(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Oracle Style packages on postgres |
| Date: | 2005-05-09 11:33:47 |
| Message-ID: | 1115638427.4784.7.camel@fuji.krosing.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)skype(dot)net>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2005-05-09 11:57:26 | Re: How to make lazy VACUUM of one table run in several |
| Previous Message | Oleg Bartunov | 2005-05-09 07:58:20 | Re: test bed |