Re: Dependency isn't created between extension and schema

2020-12-31 Thread Masahiko Sawada
On Tue, Dec 22, 2020 at 1:03 AM Tom Lane wrote: > > James Coleman writes: > > On Mon, Dec 21, 2020 at 2:59 AM Michael Paquier wrote: > >> On Mon, Dec 21, 2020 at 04:02:29PM +0900, Masahiko Sawada wrote: > >>> Is it a bug? Since the created schema obviously depends on the > >>> extension when we

Re: Dependency isn't created between extension and schema

2020-12-21 Thread Tom Lane
James Coleman writes: > On Mon, Dec 21, 2020 at 2:59 AM Michael Paquier wrote: >> On Mon, Dec 21, 2020 at 04:02:29PM +0900, Masahiko Sawada wrote: >>> Is it a bug? Since the created schema obviously depends on the >>> extension when we created the schema specified in the schema option, I >>>

Re: Dependency isn't created between extension and schema

2020-12-21 Thread James Coleman
On Mon, Dec 21, 2020 at 2:59 AM Michael Paquier wrote: > > On Mon, Dec 21, 2020 at 04:02:29PM +0900, Masahiko Sawada wrote: > > Is it a bug? Since the created schema obviously depends on the > > extension when we created the schema specified in the schema option, I > > think we might want to

Re: Dependency isn't created between extension and schema

2020-12-20 Thread Michael Paquier
On Mon, Dec 21, 2020 at 04:02:29PM +0900, Masahiko Sawada wrote: > Is it a bug? Since the created schema obviously depends on the > extension when we created the schema specified in the schema option, I > think we might want to create the dependency so that DROP EXTENSION > drops the schema as

Dependency isn't created between extension and schema

2020-12-20 Thread Masahiko Sawada
Hi all, While analyzing the issue James reported to us, I realized that if the schema option in the control file is specified and the schema doesn’t exist we create the schema on CREATE EXTENSION but the created schema doesn’t refer to the extension. Due to this behavior, the schema remains even