Re: can we create index/constraints in different schema

From: navneet nikku <navneetnikks(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: can we create index/constraints in different schema
Date: 2019-05-14 08:34:53
Message-ID: CAO9ZjbtSo5pvv-Z92i7cOfkNQwd1pHedUBVOewXT8+wDTut4Ug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ok, thanks for the clarification.
Regards
Navneet

On Tue, May 14, 2019 at 4:33 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Tue, May 14, 2019 at 03:41:37AM -0400, navneet nikku wrote:
> > This is working in Oracle but not in postgresql 'CREATE INDEX
> > client.test_1_idx
> > ON dbo.test_1 (name);' . Can we implement this by another way?
>
> No, it is not possible to define a schema with CREATE INDEX, and an
> index gets located in the same schema as its depending table.
> --
> Michael
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message 张连壮 2019-05-14 09:00:24 Re: pg_stat_database update stats_reset only by pg_stat_reset
Previous Message Michael Paquier 2019-05-14 08:33:38 Re: can we create index/constraints in different schema