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
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) |