Getting a error on creating a partition table index 12.2.

From: nikhil raj <nikhilraj474(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Getting a error on creating a partition table index 12.2.
Date: 2020-03-05 18:04:38
Message-ID: CAG1ps1zLv1wozG2PacTDHSS1KuDuhXE2UiKX4Wec+OzoHr8iLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI ALL,

While creating the index on the partition table i am getting error on it
saying

*ERROR: cannot specify default tablespace for partitioned relations SQL
state: 0A00.*

Query is

* CREATE INDEX t_e20so1_doi_c_doid_idx ON public.t_e20so1_doi USING
btree (i_doid ASC NULLS LAST) TABLESPACE pg_default;*

Note:- but the same query is executed in the 12.1 version.its working fine.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stan 2020-03-05 18:05:16 Re: A question about the number of times a trigger will fire
Previous Message Virendra Kumar 2020-03-05 17:06:17 Re: Real application clustering in postgres.