Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qvE20-0040AF-WF for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Oct 2023 09:49:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qvE1y-005RS9-VQ for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Oct 2023 09:48:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qvDwL-005PMW-OE for pgsql-bugs@lists.postgresql.org; Tue, 24 Oct 2023 09:43:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qvDwI-002Qtz-FZ for pgsql-bugs@lists.postgresql.org; Tue, 24 Oct 2023 09:43:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=OFaAfU9eKsMfGGKvmHXzK4u6tEcsq+5olS3HlQUGLvs=; b=SQaD37vzH/VUlCEqAhwc8sH779 geKvoZ57qdUYir6epaPLmOD7hC8SpZLICWVTnLQqlt1S4Xx3rqme5eSKjWJib4DrI6ydw7d3QsO94 aTE1j2DhD32l5546qDFt6Cp8dXYJrPobOAPkNw+bB6NDGujVEDZgSwyrDzTAYQ04EcFX84EAKmogj dJ49zX5ugG7v/Sz0WWQ7tgoFiE5DlIfKflvAQys0OZ9f1+DLoOpRhCguUwsTSos39Z8/4TN0gexZ/ p1EDLuo99Iv6e11sNtqTxTBdbnYHDc5YD1kqWxXtjgaJ5m6XiQ9FDHV2KSdf+vwkAMGDgI+9NQGCD i/4GzmVg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qvDwG-0000Uk-Ec for pgsql-bugs@lists.postgresql.org; Tue, 24 Oct 2023 09:43:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qvDwD-007pJb-SU for pgsql-bugs@lists.postgresql.org; Tue, 24 Oct 2023 09:43:03 +0000 Content-Type: multipart/mixed; boundary="===============1205923757741179404==" MIME-Version: 1.0 Subject: BUG #18167: cannot create partitioned tables when default_tablespace is set To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mariusraicu@laposte.net Reply-To: mariusraicu@laposte.net, pgsql-bugs@lists.postgresql.org Date: Tue, 24 Oct 2023 09:42:28 +0000 Message-ID: <18167-fcc9f9f33cddf04d@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1205923757741179404== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE2NwpMb2dnZWQgYnk6ICAgICAgICAgIE1hcml1cyBSYWljdQpFbWFp bCBhZGRyZXNzOiAgICAgIG1hcml1c3JhaWN1QGxhcG9zdGUubmV0ClBvc3RncmVTUUwgdmVyc2lv bjogMTYuMApPcGVyYXRpbmcgc3lzdGVtOiAgIFJlZEhhdCA4CkRlc2NyaXB0aW9uOiAgICAgICAg CgpIZWxsbyBhbGwsDQoNCkkgYW0gZW5jb3VudGVyaW5nIHNvbWUgcHJvYmxlbXMgd2hlbiBjcmVh dGluZyBwYXJ0aXRpb25lZCB0YWJsZXMgd2hlbgpkZWZhdWx0X3RhYmxlc3BhY2UgcGFyYW1ldGVy IGlzIHNldC4NCg0KSSBhbSBub3Qgc3VyZSBpZiBpdCBpcyBhIGJ1ZyBvciBtYXliZSBJIGRvbid0 IHVuZGVyc3RhbmQgdGhlIGRvY3VtZW50YXRpb24KY29ycmVjdGx5LiBJbiB0aGUgZG9jLCBpdCBp cyBzdGF0ZWQ6DQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzE2L3NxbC1jcmVhdGV0 YWJsZS5odG1sDQpUQUJMRVNQQUNFIHRhYmxlc3BhY2VfbmFtZSANClRoZSB0YWJsZXNwYWNlX25h bWUgaXMgdGhlIG5hbWUgb2YgdGhlIHRhYmxlc3BhY2UgaW4gd2hpY2ggdGhlIG5ldyB0YWJsZSBp cwp0byBiZSBjcmVhdGVkLiBJZiBub3Qgc3BlY2lmaWVkLCBkZWZhdWx0X3RhYmxlc3BhY2UgaXMg Y29uc3VsdGVkLCBvcgp0ZW1wX3RhYmxlc3BhY2VzIGlmIHRoZSB0YWJsZSBpcyB0ZW1wb3Jhcnku IEZvciBwYXJ0aXRpb25lZCB0YWJsZXMsIHNpbmNlIG5vCnN0b3JhZ2UgaXMgcmVxdWlyZWQgZm9y IHRoZSB0YWJsZSBpdHNlbGYsIHRoZSB0YWJsZXNwYWNlIHNwZWNpZmllZCBvdmVycmlkZXMKZGVm YXVsdF90YWJsZXNwYWNlIGFzIHRoZSBkZWZhdWx0IHRhYmxlc3BhY2UgdG8gdXNlIGZvciBhbnkg bmV3bHkgY3JlYXRlZApwYXJ0aXRpb25zIHdoZW4gbm8gb3RoZXIgdGFibGVzcGFjZSBpcyBleHBs aWNpdGx5IHNwZWNpZmllZC4NCg0KVVNJTkcgSU5ERVggVEFCTEVTUEFDRSB0YWJsZXNwYWNlX25h bWUgDQpUaGlzIGNsYXVzZSBhbGxvd3Mgc2VsZWN0aW9uIG9mIHRoZSB0YWJsZXNwYWNlIGluIHdo aWNoIHRoZSBpbmRleCBhc3NvY2lhdGVkCndpdGggYSBVTklRVUUsIFBSSU1BUlkgS0VZLCBvciBF WENMVURFIGNvbnN0cmFpbnQgd2lsbCBiZSBjcmVhdGVkLiBJZiBub3QKc3BlY2lmaWVkLCBkZWZh dWx0X3RhYmxlc3BhY2UgaXMgY29uc3VsdGVkLCBvciB0ZW1wX3RhYmxlc3BhY2VzIGlmIHRoZSB0 YWJsZQppcyB0ZW1wb3JhcnkuDQoNCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTYv cnVudGltZS1jb25maWctY2xpZW50Lmh0bWwjR1VDLURFRkFVTFQtVEFCTEVTUEFDRQ0KZGVmYXVs dF90YWJsZXNwYWNlIChzdHJpbmcpIA0KVGhpcyB2YXJpYWJsZSBzcGVjaWZpZXMgdGhlIGRlZmF1 bHQgdGFibGVzcGFjZSBpbiB3aGljaCB0byBjcmVhdGUgb2JqZWN0cwoodGFibGVzIGFuZCBpbmRl eGVzKSB3aGVuIGEgQ1JFQVRFIGNvbW1hbmQgZG9lcyBub3QgZXhwbGljaXRseSBzcGVjaWZ5IGEK dGFibGVzcGFjZS4NCg0KVGhlIHZhbHVlIGlzIGVpdGhlciB0aGUgbmFtZSBvZiBhIHRhYmxlc3Bh Y2UsIG9yIGFuIGVtcHR5IHN0cmluZyB0byBzcGVjaWZ5CnVzaW5nIHRoZSBkZWZhdWx0IHRhYmxl c3BhY2Ugb2YgdGhlIGN1cnJlbnQgZGF0YWJhc2UuIElmIHRoZSB2YWx1ZSBkb2VzIG5vdAptYXRj aCB0aGUgbmFtZSBvZiBhbnkgZXhpc3RpbmcgdGFibGVzcGFjZSwgUG9zdGdyZVNRTCB3aWxsIGF1 dG9tYXRpY2FsbHkgdXNlCnRoZSBkZWZhdWx0IHRhYmxlc3BhY2Ugb2YgdGhlIGN1cnJlbnQgZGF0 YWJhc2UuIElmIGEgbm9uZGVmYXVsdCB0YWJsZXNwYWNlCmlzIHNwZWNpZmllZCwgdGhlIHVzZXIg bXVzdCBoYXZlIENSRUFURSBwcml2aWxlZ2UgZm9yIGl0LCBvciBjcmVhdGlvbgphdHRlbXB0cyB3 aWxsIGZhaWwuDQoNClRoaXMgdmFyaWFibGUgaXMgbm90IHVzZWQgZm9yIHRlbXBvcmFyeSB0YWJs ZXM7IGZvciB0aGVtLCB0ZW1wX3RhYmxlc3BhY2VzCmlzIGNvbnN1bHRlZCBpbnN0ZWFkLg0KDQpU aGlzIHZhcmlhYmxlIGlzIGFsc28gbm90IHVzZWQgd2hlbiBjcmVhdGluZyBkYXRhYmFzZXMuIEJ5 IGRlZmF1bHQsIGEgbmV3CmRhdGFiYXNlIGluaGVyaXRzIGl0cyB0YWJsZXNwYWNlIHNldHRpbmcg ZnJvbSB0aGUgdGVtcGxhdGUgZGF0YWJhc2UgaXQgaXMKY29waWVkIGZyb20uDQoNCklmIHRoaXMg cGFyYW1ldGVyIGlzIHNldCB0byBhIHZhbHVlIG90aGVyIHRoYW4gdGhlIGVtcHR5IHN0cmluZyB3 aGVuIGEKcGFydGl0aW9uZWQgdGFibGUgaXMgY3JlYXRlZCwgdGhlIHBhcnRpdGlvbmVkIHRhYmxl J3MgdGFibGVzcGFjZSB3aWxsIGJlIHNldAp0byB0aGF0IHZhbHVlLCB3aGljaCB3aWxsIGJlIHVz ZWQgYXMgdGhlIGRlZmF1bHQgdGFibGVzcGFjZSBmb3IgcGFydGl0aW9ucwpjcmVhdGVkIGluIHRo ZSBmdXR1cmUsIGV2ZW4gaWYgZGVmYXVsdF90YWJsZXNwYWNlIGhhcyBjaGFuZ2VkIHNpbmNlIHRo ZW4uDQoNClNlZSB0aGUgc2VxdWVuY2UgYmVsb3c6DQoNClttYXJpdXNAbXlsYXB0b3Agfl0kIHBz cWwNCnBzcWwgKDE3ZGV2ZWwpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KbWFyaXVzQFtsb2Nh bF06NTQzNC9wb3N0Z3Jlcz0jIHNob3cgZGVmYXVsdF90YWJsZXNwYWNlOw0KIGRlZmF1bHRfdGFi bGVzcGFjZSANCi0tLS0tLS0tLS0tLS0tLS0tLS0tDQogDQooMSByb3cpDQoNCm1hcml1c0BbbG9j YWxdOjU0MzQvcG9zdGdyZXM9IyBjcmVhdGUgdGFibGUgdG90byhpZCBudW1lcmljKSBwYXJ0aXRp b24gYnkKbGlzdChpZCk7DQpDUkVBVEUgVEFCTEUNCm1hcml1c0BbbG9jYWxdOjU0MzQvcG9zdGdy ZXM9IyBkcm9wIHRhYmxlIHRvdG87DQpEUk9QIFRBQkxFDQptYXJpdXNAW2xvY2FsXTo1NDM0L3Bv c3RncmVzPSMgXCEgbWtkaXIgL2hvbWUvbWFyaXVzL3BnY29kZS90YmxzcGMxDQptYXJpdXNAW2xv Y2FsXTo1NDM0L3Bvc3RncmVzPSMgXCEgbHMgL2hvbWUvbWFyaXVzL3BnY29kZQ0KYmluICBwZ2Rh dGEgIHBvc3RncmVzcWwgIHRibHNwYzENCm1hcml1c0BbbG9jYWxdOjU0MzQvcG9zdGdyZXM9IyBc cQ0KW21hcml1c0BteWxhcHRvcCB+XSQgdmkgJFBHREFUQS9wb3N0Z3Jlc3FsLmNvbmYNClttYXJp dXNAbXlsYXB0b3Agfl0kIA0KW21hcml1c0BteWxhcHRvcCB+XSQgcGdfY3RsIHJlc3RhcnQNCndh aXRpbmcgZm9yIHNlcnZlciB0byBzaHV0IGRvd24uLi4uIGRvbmUNCnNlcnZlciBzdG9wcGVkDQp3 YWl0aW5nIGZvciBzZXJ2ZXIgdG8gc3RhcnQuLi4uMjAyMy0xMC0yNCAxMToxNDoyMS42MzYgQ0VT VCBbNTgwMF0gTE9HOiAKcmVkaXJlY3RpbmcgbG9nIG91dHB1dCB0byBsb2dnaW5nIGNvbGxlY3Rv ciBwcm9jZXNzDQoyMDIzLTEwLTI0IDExOjE0OjIxLjYzNiBDRVNUIFs1ODAwXSBISU5UOiAgRnV0 dXJlIGxvZyBvdXRwdXQgd2lsbCBhcHBlYXIgaW4KZGlyZWN0b3J5ICJsb2ciLg0KIGRvbmUNCnNl cnZlciBzdGFydGVkDQpbbWFyaXVzQG15bGFwdG9wIH5dJCBwc3FsDQpwc3FsICgxN2RldmVsKQ0K VHlwZSAiaGVscCIgZm9yIGhlbHAuDQoNCm1hcml1c0BbbG9jYWxdOjU0MzQvcG9zdGdyZXM9IyBz aG93IGRlZmF1bHRfdGFibGVzcGFjZTsNCiBkZWZhdWx0X3RhYmxlc3BhY2UgDQotLS0tLS0tLS0t LS0tLS0tLS0tLQ0KIHRibHNwYzENCigxIHJvdykNCg0KbWFyaXVzQFtsb2NhbF06NTQzNC9wb3N0 Z3Jlcz0jIGNyZWF0ZSB0YWJsZXNwYWNlIHRibHNwYzEgbG9jYXRpb24KJy9ob21lL21hcml1cy9w Z2NvZGUvdGJsc3BjMSc7DQpDUkVBVEUgVEFCTEVTUEFDRQ0KbWFyaXVzQFtsb2NhbF06NTQzNC9w b3N0Z3Jlcz0jIGNyZWF0ZSBkYXRhYmFzZSB0ZXN0IHRhYmxlc3BhY2UgdGJsc3BjMTsNCkNSRUFU RSBEQVRBQkFTRQ0KbWFyaXVzQFtsb2NhbF06NTQzNC9wb3N0Z3Jlcz0jIFxjIHRlc3QNCllvdSBh cmUgbm93IGNvbm5lY3RlZCB0byBkYXRhYmFzZSAidGVzdCIgYXMgdXNlciAibWFyaXVzIi4NCm1h cml1c0BbbG9jYWxdOjU0MzQvdGVzdD0jIGNyZWF0ZSB0YWJsZSB0b3RvKGlkIG51bWVyaWMpIHBh cnRpdGlvbiBieQpsaXN0KGlkKTsNCkVSUk9SOiAgY2Fubm90IHNwZWNpZnkgZGVmYXVsdCB0YWJs ZXNwYWNlIGZvciBwYXJ0aXRpb25lZCByZWxhdGlvbnMNCm1hcml1c0BbbG9jYWxdOjU0MzQvdGVz dD0jIGNyZWF0ZSB0YWJsZSB0b3RvKGlkIG51bWVyaWMsIGNvbnN0cmFpbnQgcGtfaWQKcHJpbWFy eSBrZXkoaWQpIHVzaW5nIGluZGV4IHRhYmxlc3BhY2UgdGJsc3BjMSkgcGFydGl0aW9uIGJ5IGxp c3QoaWQpOw0KRVJST1I6ICBjYW5ub3Qgc3BlY2lmeSBkZWZhdWx0IHRhYmxlc3BhY2UgZm9yIHBh cnRpdGlvbmVkIHJlbGF0aW9ucw0KDQoNCm1hcml1c0BbbG9jYWxdOjU0MzQvcG9zdGdyZXM9IyBc YyB0ZXN0DQpZb3UgYXJlIG5vdyBjb25uZWN0ZWQgdG8gZGF0YWJhc2UgInRlc3QiIGFzIHVzZXIg Im1hcml1cyIuDQptYXJpdXNAW2xvY2FsXTo1NDM0L3Rlc3Q9IyBjcmVhdGUgdGFibGUgdG90bzIo aWQgbnVtZXJpYywgY29uc3RyYWludCBwa19pZApwcmltYXJ5IGtleShpZCkgdXNpbmcgaW5kZXgg dGFibGVzcGFjZSB0YmxzcGMxKSBwYXJ0aXRpb24gYnkgbGlzdChpZCk7DQpFUlJPUjogIGNhbm5v dCBzcGVjaWZ5IGRlZmF1bHQgdGFibGVzcGFjZSBmb3IgcGFydGl0aW9uZWQgcmVsYXRpb25zDQpt YXJpdXNAW2xvY2FsXTo1NDM0L3Rlc3Q9IyBjcmVhdGUgdGFibGUgdG90byhpZCBudW1lcmljKSBw YXJ0aXRpb24gYnkKbGlzdChpZCkgdGFibGVzcGFjZSB0YmxzcGMxOw0KRVJST1I6ICBjYW5ub3Qg c3BlY2lmeSBkZWZhdWx0IHRhYmxlc3BhY2UgZm9yIHBhcnRpdGlvbmVkIHJlbGF0aW9ucw0KbWFy aXVzQFtsb2NhbF06NTQzNC90ZXN0PSMgY3JlYXRlIHRhYmxlIHRvdG8oaWQgbnVtZXJpYykgcGFy dGl0aW9uIGJ5Cmxpc3QoaWQpOw0KRVJST1I6ICBjYW5ub3Qgc3BlY2lmeSBkZWZhdWx0IHRhYmxl c3BhY2UgZm9yIHBhcnRpdGlvbmVkIHJlbGF0aW9ucw0KbWFyaXVzQFtsb2NhbF06NTQzNC90ZXN0 PSMgY3JlYXRlIHRhYmxlIHRvdG8yKGlkIG51bWVyaWMsIGNvbnN0cmFpbnQgcGtfaWQKcHJpbWFy eSBrZXkoaWQpKSBwYXJ0aXRpb24gYnkgbGlzdChpZCk7DQpFUlJPUjogIGNhbm5vdCBzcGVjaWZ5 IGRlZmF1bHQgdGFibGVzcGFjZSBmb3IgcGFydGl0aW9uZWQgcmVsYXRpb25zDQoNCkhvd2V2ZXIs IGluIGFub3RoZXIgZGF0YWJhc2UsICdwb3N0Z3JlcycgYnkgZXhhbXBsZSwgd2hpY2ggd2FzIGNy ZWF0ZWQgaW4KdGhlIGRlZmF1bHQgdGFibGVzcGFjZSAnJyAobm8gdGFibGVzcGFjZSBhdCBhbGwp LCBpdCB3b3JrczoNCg0KbWFyaXVzQFtsb2NhbF06NTQzNC9wb3N0Z3Jlcz0jIGNyZWF0ZSB0YWJs ZSB0b3RvKGlkIG51bWVyaWMpIHBhcnRpdGlvbiBieQpsaXN0KGlkKSB0YWJsZXNwYWNlIHRibHNw YzE7DQpDUkVBVEUgVEFCTEUNCm1hcml1c0BbbG9jYWxdOjU0MzQvcG9zdGdyZXM9IyBjcmVhdGUg dGFibGUgdG90bzIoaWQgbnVtZXJpYywgY29uc3RyYWludApwa19pZCBwcmltYXJ5IGtleShpZCkg dXNpbmcgaW5kZXggdGFibGVzcGFjZSB0YmxzcGMxKSBwYXJ0aXRpb24gYnkKbGlzdChpZCk7DQpD UkVBVEUgVEFCTEUNCg0KDQpJIHdhcyBhYmxlIHRvIHJlcHJvZHVjZSB0aGlzIGJlaGF2aW9yIG9u IGFsbCB2ZXJzaW9ucyBzdGFydGluZyB0byBQRzEyLg0KU28sIHdoZW4gdGhlIGRlZmF1bHQgX3Rh Ymxlc3BhY2UgaXMgc2V0LCB5b3UgaGF2ZSB0byBzcGVjaWZ5IHRoZSB0YWJsZXNwYWNlCmNsYXVz ZSB0byBDUkVBVEUgVEFCTEUsIGRlc3BpdGUgdGhlIGZhY3QgdGhhdCB0aGUgZGF0YWJhc2Ugd2hl cmUgeW91IHRyeSB0bwpwdXQgdGhlIHRhYmxlIGlzIGNyZWF0ZWQgaW50byBhIHRhYmxlc3BhY2Uu DQoNClRoYW5rcywNCk1hcml1cyBSYWljdQoK --===============1205923757741179404==--