| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Miha Vrhovnik <miha(dot)vrhovnik(at)gmail(dot)com> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org> |
| Subject: | Re: BUG #16698: Create extension and search path |
| Date: | 2020-11-03 17:50:26 |
| Message-ID: | 957260.1604425826@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Miha Vrhovnik <miha(dot)vrhovnik(at)gmail(dot)com> writes:
> What are then extensions.. They live in some sort of limbo.. as they don't
> behave like a natural extension of the database... As they behave
> differently (because they "require" public shema in path if extensions are
> created while in public schema ).
You've got the wrong mental model. Extensions are containers, which
may *contain* objects that live within schemas, but the extension itself
does not. The key reason for doing it that way is that an extension might
itself contain a schema, or more than one schema.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wolfgang Walther | 2020-11-03 18:05:32 | Re: User with BYPASSRLS privilege can't change password |
| Previous Message | Tom Lane | 2020-11-03 17:44:11 | Re: User with BYPASSRLS privilege can't change password |