Re: 12.1 Partitioned Table Creation Bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Drawater <Chris(dot)Drawater(at)viavisolutions(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: 12.1 Partitioned Table Creation Bug
Date: 2020-01-22 19:47:57
Message-ID: 25735.1579722477@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Chris Drawater <Chris(dot)Drawater(at)viavisolutions(dot)com> writes:
> geo=> create table junk ( a int, b int) PARTITION BY RANGE (a);
> ERROR: cannot specify default tablespace for partitioned relations

I'm guessing you've got default_tablespace set to something nonempty.

I don't know why the decision was made to throw an error rather than
silently ignoring the setting ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2020-01-22 21:39:32 Re: 12.1 Partitioned Table Creation Bug
Previous Message Ruud van Asseldonk 2020-01-22 17:30:12 Re: High table creation rate results in “File exists” error