Re: Package-support plans?

From: Nicklas Karlsson <nickarls(at)gmail(dot)com>
To: spam_eater(at)gmx(dot)net
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Package-support plans?
Date: 2018-11-20 07:39:23
Message-ID: CAFzcPXFM2O53Pe2w0GN0OM+08dm6hei99ztiSeiSZ6KYAULeig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes, that it surely one option but is there any grant that can be made on a
function so that it can only be called from within the same schema? Even
then it is a bit cumbersome

On Tue, Nov 20, 2018 at 9:12 AM Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> Nicklas Karlsson schrieb am 20.11.2018 um 07:32:
> > Are there any plans for including Oracle-style packages with
> > namespace/visibility support at some point or is it just "use
> > schemas"? I could even live without package-state but I find it
> > frustrating with the namespace pollution when the application grows.
> >
>
> If you don't need package-level variables, you could use schemas put
> functions in different namespaces.
>
> create schema package_one;
> create function package_one.function_one() as ...;
>
> create schema package_two;
> create function package_two.function_two() as ...;
>
>
>
>
>
>
>

--
Nicklas Karlsson, +358 40 5062266
Vaakunatie 10 as 7, 20780 Kaarina

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2018-11-20 08:22:19 Re: Package-support plans?
Previous Message Пацев Антон 2018-11-20 07:18:40 Get link postgresql repo from command line (Send REST or POST request)