can we create index/constraints in different schema

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

can we create index/constraints in different schema

navneet nikku
Hi,
   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?

Thanks 
Navneet
Reply | Threaded
Open this post in threaded view
|

Re: can we create index/constraints in different schema

Michael Paquier-2
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

signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: can we create index/constraints in different schema

navneet nikku
Ok, thanks for the clarification. 
Regards 
Navneet

On Tue, May 14, 2019 at 4:33 AM Michael Paquier <[hidden email]> 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