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;
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.