Re: [HACKERS] Note about comparation PL/SQL packages and our schema/extensions

On 5 November 2015 at 14:36, Pavel Stehule wrote: > 1. The encapsulation and local scope - all objects in schema are accessible > from other objects in schema by default (can be rewritten by explicit > granting). Local objects are visible only from objects in schema.

Re: [HACKERS] Note about comparation PL/SQL packages and our schema/extensions

On 11/05/2015 01:31 PM, Craig Ringer wrote: On 5 November 2015 at 14:36, Pavel Stehule wrote: [snip] 2. The schema variables - a server side session (can be emulated now) and server side local schema session variables (doesn't exist) is pretty useful for storing some

Re: [HACKERS] Note about comparation PL/SQL packages and our schema/extensions

On Thu, Nov 5, 2015 at 9:36 AM, Pavel Stehule wrote: > Hi > > I had talk about possibility to implement PL/SQL packages in Postgres. > > The package concept is coming from ADA language and it is partially > foreign/redundant element in SQL world. Oracle needs it for

Re: [HACKERS] Note about comparation PL/SQL packages and our schema/extensions

2015-11-05 21:29 GMT+01:00 Pavel Stehule : > > > 2015-11-05 13:31 GMT+01:00 Craig Ringer : > >> On 5 November 2015 at 14:36, Pavel Stehule >> wrote: >> >> > 1. The encapsulation and local scope - all objects in schema are

Re: [HACKERS] Note about comparation PL/SQL packages and our schema/extensions

2015-11-05 13:31 GMT+01:00 Craig Ringer : > On 5 November 2015 at 14:36, Pavel Stehule > wrote: > > > 1. The encapsulation and local scope - all objects in schema are > accessible > > from other objects in schema by default (can be rewritten by

[HACKERS] Note about comparation PL/SQL packages and our schema/extensions

Hi I had talk about possibility to implement PL/SQL packages in Postgres. The package concept is coming from ADA language and it is partially foreign/redundant element in SQL world. Oracle needs it for modularization, because schema plays different role there than in Postgres. My opinion about