Re: Oracle Style packages on postgres

From: Thomas Hallgren <thhal(at)mailblocks(dot)com>
To: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
Cc: "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 05:36:21
Message-ID: thhal-0WY9aAyuNyiciGcIWV5kvwvqJ8eCQRg@mailblocks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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. It is not
available from other languages at present. Are Packages supposed to be
cross-language?

Regards,
Thomas Hallgren

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2005-05-09 07:58:20 Re: test bed
Previous Message Greg Stark 2005-05-09 05:31:55 Re: pl/pgsql enabled by default