From: | Gustavo <gustavomilc(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: CREATE EXTENSION not adding extension on second SCHEMA |
Date: | 2022-05-31 16:58:24 |
Message-ID: | CAKyyQ7foAp2hKGXiN6RpfqSweiPJAJDm+cAQnFKnhyTFbnznTg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Thank you so much guys, my mistake I didn't pay attention. I'm new
to PostgreSQL and your help is much appreciated!
Em ter., 31 de mai. de 2022 às 12:32, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escreveu:
> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> > On Tuesday, May 31, 2022, PG Doc comments form <noreply(at)postgresql(dot)org>
> > wrote:
> >> I'm trying to add an extension to two schemas that I have in my DB.
>
> > It doesn’t work and isn’t documented as something that does work. I
> really
> > don’t see a need to say you cannot install the same extension multiple
> > times explicitly - the self-describing error seems sufficient.
>
> The CREATE EXTENSION reference page says
>
> "There must not be an extension of the same name already loaded."
>
> and later
>
> "Remember that the extension itself is not considered to be within any
> schema: extensions have unqualified names that must be unique
> database-wide. But objects belonging to the extension can be within
> schemas."
>
> I hardly see how we could make this any plainer.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan S. Katz | 2022-05-31 18:47:23 | Re: Can we still dump version 7? |
Previous Message | Tom Lane | 2022-05-31 16:21:09 | Re: Can we still dump version 7? |