Re: 12.1 Partitioned Table Creation Bug
| От | David G. Johnston |
|---|---|
| Тема | Re: 12.1 Partitioned Table Creation Bug |
| Дата | |
| Msg-id | CAKFQuwZLsGaz2fS8F-sNxmZMRL=z=AA_BepmP3YxEyVxXEmqig@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: 12.1 Partitioned Table Creation Bug (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: 12.1 Partitioned Table Creation Bug
|
| Список | pgsql-bugs |
On Wed, Jan 22, 2020 at 12:48 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 ...
Ignoring the setting seems to be what the documentation says we do:
"For partitioned tables, since no storage is required for the table itself, the tablespace specified overrides default_tablespace as the default tablespace to use for any newly created partitions when no other tablespace is explicitly specified."
So this seems like a regression in v12.
David J.
В списке pgsql-bugs по дате отправления: