Postgres Pro
Downloads
Home   >   mailing lists

12.1 Partitioned Table Creation Bug - Mailing list pgsql-bugs

From Chris Drawater
Subject 12.1 Partitioned Table Creation Bug
Date
Msg-id BY5PR18MB3170E372542F34694E630B12F10C0@BY5PR18MB3170.namprd18.prod.outlook.com
Whole thread Raw
Responses Re: 12.1 Partitioned Table Creation Bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
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.
 
 
 
 
Attachment

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #16226: background worker "logical replication worker" (PID) was terminated by signal 11: Segmentation
Next
From: Michael Paquier
Date:
Subject: Re: BUG #16226: background worker "logical replication worker" (PID) was terminated by signal 11: Segmentation