Re: Oracle Style packages on postgres
Josh Berkus <josh@agliodbs.com>
From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: rmm@sqlisor.com, pgsql-hackers@postgresql.org
Date: 2005-05-09T19:30:40Z
Lists: pgsql-hackers
Tom, > What I read in this thread is that the only truly missing feature is > package variables (ie, session-local variables); is that an accurate > statement? If so, it would seem simplest to add such a feature to > plpgsql and be done with it. Several people already pointed out that > most of the other PLs support that feature today. Also initialization, namespacing, and security. The ability to "package" bunches of functions, and only allow their calling in the context of a package, is quite valuable in installations which support 1,000's of procedures. -- --Josh Josh Berkus Aglio Database Solutions San Francisco