12.1 Partitioned Table Creation Bug

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(at)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<http://www.viavisolutions.com/>

Follow us on:
Viavi Perspectives<http://blog.viavisolutions.com/> │ LinkedIn<https://www.linkedin.com/company/viavi-solutions?trk=nav_account_sub_nav_company_admin> │ Twitter<http://www.twitter.com/viavisolutions> │ YouTube<https://www.youtube.com/channel/UCCCGcTKD1teKf8VyaEKm-MA> │Facebook<https://www.facebook.com/viavisolutions>

[cid:image001(dot)jpg(at)01D1FC8E(dot)7D083320]

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.

* Please consider the environment before printing this email.