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