| 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: | Whole Thread | Raw Message | 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) |