Postgres Pro
Downloads
Home   >   mailing lists

Re: 12.1 Partitioned Table Creation Bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: 12.1 Partitioned Table Creation Bug
Date
Msg-id 25735.1579722477@sss.pgh.pa.us
Whole thread Raw
In response to 12.1 Partitioned Table Creation Bug  (Chris Drawater <Chris.Drawater@viavisolutions.com>)
Responses Re: 12.1 Partitioned Table Creation Bug  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
Chris Drawater <Chris.Drawater@viavisolutions.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

pgsql-bugs by date:

Previous
From: Ruud van Asseldonk
Date:
Subject: Re: High table creation rate results in “File exists” error
Next
From: "David G. Johnston"
Date:
Subject: Re: 12.1 Partitioned Table Creation Bug