12.1 Partitioned Table Creation Bug

Поиск
Список
Период
Сортировка
От Chris Drawater
Тема 12.1 Partitioned Table Creation Bug
Дата
Msg-id BY5PR18MB3170E372542F34694E630B12F10C0@BY5PR18MB3170.namprd18.prod.outlook.com
обсуждение исходный текст
Ответы Re: 12.1 Partitioned Table Creation Bug  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
A pretty simple case attached  :  attempting to create a partitioned table via psql  fails à
 
Psql can be either be a remote Windows  PG 11.0 client or a Linux PG 12.1 client ( same node as PG server) – makes no difference.
 
---
 
[postgres@ssd1 pg_scripts]$ cat /etc/system-release
CentOS Linux release 7.7.1908 (Core)
 
 
geo=> select version();
                                                 version
---------------------------------------------------------------------------------------------------------
PostgreSQL 12.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
(1 row)
 
geo=> create table junk ( a int, b int) PARTITION BY RANGE (a);
ERROR:  cannot specify default tablespace for partitioned relations
 
Or
 
geo=> create table junk (a int,b int) partition by list(a);
ERROR:  cannot specify default tablespace for partitioned relations
 
I tried cut/paste and typing in the command from scratch to preclude control character issues.
 
-----------------------------------------------------------
 
Note , the non-partitioned table DDL below works fine à
 
geo=> create table junk ( a int, b int);
CREATE TABLE
 
 
All my application partitioned table DDL works OK on PG 11.1 on CentOS Linux release 7.3.1611 (Core)  but none on 12.1…
 
I’d be surprised if something so fundamental is a bug but just in case, I thought I’d submit it….
 
 
Chris Drawater
Database Architect

Viavi Solutions
Astor House, Newbury Business Park, London Road
Newbury, Berkshire  RG14 2PZ  UK
+44 (0)1635 223000 (office)
www.viavisolutions.com
 
Follow us on:
 
 
Viavi Solutions UK Ltd. is registered in England & Wales with company number 00887400. Its registered office is Astor House, Newbury Business Park, London Road, Newbury, Berkshire, RG14 2PZ, United Kingdom. Information contained in this email is intended for the use of the addressee only, is confidential and may be legally privileged. Any further dissemination, distribution, copying or use of this communication without prior permission of the sender is strictly prohibited.
 
P Please consider the environment before printing this email.
 
 
 
 
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #16226: background worker "logical replication worker" (PID) was terminated by signal 11: Segmentation
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #16226: background worker "logical replication worker" (PID) was terminated by signal 11: Segmentation