On Tue, Jun 1, 2021, at 14:41, Pavel Stehule wrote:
I don't agree. If an extension provides functionality that is supposed to be used by all parts of the system, then I think the 'public' schema is a good choice.
I disagree
usual design of extensions (when schema is used) is
create schema ...
set schema ...
create table
create function
It is hard to say if it is good or it is bad.
Yes, it's hard, because it's a matter of taste.
Some prefer convenience, others clarity/safety.
Orafce using my own schema, and some things are in public (and some in pg_catalog), and people don't tell me, so it was a good choice.
I struggle to understand this last sentence.
So you orafce extension installs objects in both public and pg_catalog, right.
But what do you mean with "people don't tell me"?
And what "was a good choice"?
Thanks for explaining.
/Joel