On 2020-Mar-05, Adrian Klaver wrote:
> The OP was wondering why it worked in 12.1 and not 12.2?
>
> I could not see any obvious reason for that, so:
>
> 1) There is a not obvious reason
>
> 2) It did not work in 12.1 either.
(2) is correct.
55469 12.1 9913=# show server_version;
server_versi
On 3/5/20 11:31 AM, Alvaro Herrera wrote:
On 2020-Mar-05, Adrian Klaver wrote:
On 3/5/20 10:04 AM, nikhil raj wrote:
*CREATE INDEX t_e20so1_doi_c_doid_idx
ON public.t_e20so1_doi USING btree
(i_doid ASC NULLS LAST)
TABLESPACE pg_default;*
*ERROR: cannot specify default ta
On 2020-Mar-05, Adrian Klaver wrote:
> On 3/5/20 10:04 AM, nikhil raj wrote:
> > *CREATE INDEX t_e20so1_doi_c_doid_idx
> > ON public.t_e20so1_doi USING btree
> > (i_doid ASC NULLS LAST)
> > TABLESPACE pg_default;*
> > *ERROR: cannot specify default tablespace for partitioned relat
Ok, thanks for the clarification.
On Fri, Mar 6, 2020 at 12:31 AM Adrian Klaver
wrote:
> On 3/5/20 10:48 AM, nikhil raj wrote:
> > Hi Adrian,
> >
> > On that table nothing was happening just created the table and later o
> > was creating the index and i was getting this error.
> >
> > Please can
On 3/5/20 10:48 AM, nikhil raj wrote:
Hi Adrian,
On that table nothing was happening just created the table and later o
was creating the index and i was getting this error.
Please can you tell me is this the draw back of that in 12.2 version.
Unfortunately I don't have answer for you on th
Hi Adrian,
On that table nothing was happening just created the table and later o was
creating the index and i was getting this error.
Please can you tell me is this the draw back of that in 12.2 version.
On Fri, 6 Mar 2020, 12:04 am Adrian Klaver,
wrote:
> On 3/5/20 10:04 AM, nikhil raj wrote
On 3/5/20 10:04 AM, nikhil raj wrote:
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 U
