Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pUOqI-0003qY-MH for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Feb 2023 09:21:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pUOqG-0004Xq-Ur for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Feb 2023 09:21:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pUOVM-0002uX-Na for pgsql-bugs@lists.postgresql.org; Tue, 21 Feb 2023 09:00:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pUOVK-00082w-C3 for pgsql-bugs@lists.postgresql.org; Tue, 21 Feb 2023 09:00:07 +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=fLgh7HPokuHk5kLY8R1qwBB3OSld3EX/YFxyLCKwvkg=; b=TgrT9GcEwwFffHwKzLnCSkO8M9 w2sEOcz0mmvFmpgEmyqSUZ3d0UCRh7pIOX1hfOXZ28Mc2ggd7QBNVE8Qcp+bKd8n9UYvxV2GhcsS0 UelnOz+/PAnUFUnbn3x33ZMFDtuU4gYWlKEoRc/VO2JqAz8orRyaGtd+Id+8mCncKAZ07mNpanppL l5drLmKyDC2ZDk3jrugtouEcdaYTbvfbc6jYapGHELk9ocOso63d26tfY4E+Sw5az+CfiejOu92zj TZPlqy4StORfHkRq+aq/rmRFveJmRk//MZF8AzzYOYTy1K8jJQWXqkd0yjsR53q141hmgzm6M7R1w zpQN4RXw==; 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 1pUOVJ-0000XG-4G for pgsql-bugs@lists.postgresql.org; Tue, 21 Feb 2023 09:00:05 +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 1pUOVH-007qRl-6X for pgsql-bugs@lists.postgresql.org; Tue, 21 Feb 2023 09:00:02 +0000 Content-Type: multipart/mixed; boundary="===============8597609052680340484==" MIME-Version: 1.0 Subject: BUG #17803: Rule "ALSO INSERT ... SELECT ..." fails to substitute default values To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 21 Feb 2023 09:00:01 +0000 Message-ID: <17803-53c63ed4ecb4eac6@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 --===============8597609052680340484== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgwMwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBxdWVyaWVzOg0KQ1JFQVRFIFRBQkxFIHQgKGEgaW50LCBiIGlu dCBERUZBVUxUIC0xKTsNCkNSRUFURSBWSUVXIHYgQVMgU0VMRUNUICogRlJPTSB0Ow0KQ1JFQVRF IFJVTEUgdnIgQVMgT04gSU5TRVJUIFRPIHYgRE8gQUxTTyBJTlNFUlQgSU5UTyB0IFNFTEVDVCAx Ow0KSU5TRVJUIElOVE8gdiBWQUxVRVMgKDAsIERFRkFVTFQpLCAoMSwgREVGQVVMVCk7DQoNCmxl YWQgdG8gYW4gYXNzZXJ0IGZvciBtZToNCkNvcmUgd2FzIGdlbmVyYXRlZCBieSBgcG9zdGdyZXM6 IGxhdyByZWdyZXNzaW9uIFtsb2NhbF0gSU5TRVJUICAgICAgICAgICAgICAKICAgICAgICAgICAg ICAgICAgICAgICAgJy4NClByb2dyYW0gdGVybWluYXRlZCB3aXRoIHNpZ25hbCBTSUdBQlJULCBB Ym9ydGVkLg0KDQp3YXJuaW5nOiBTZWN0aW9uIGAucmVnLXhzdGF0ZS8xMTkyNDIyJyBpbiBjb3Jl IGZpbGUgdG9vIHNtYWxsLg0KIzAgIF9fcHRocmVhZF9raWxsX2ltcGxlbWVudGF0aW9uIChub190 aWQ9MCwgc2lnbm89NiwKdGhyZWFkaWQ9MTQwMDQ0ODYyMDMxNjgwKSBhdCAuL25wdGwvcHRocmVh ZF9raWxsLmM6NDQNCjQ0ICAgICAgLi9ucHRsL3B0aHJlYWRfa2lsbC5jOiBObyBzdWNoIGZpbGUg b3IgZGlyZWN0b3J5Lg0KKGdkYikgYnQNCiMwICBfX3B0aHJlYWRfa2lsbF9pbXBsZW1lbnRhdGlv biAobm9fdGlkPTAsIHNpZ25vPTYsCnRocmVhZGlkPTE0MDA0NDg2MjAzMTY4MCkgYXQgLi9ucHRs L3B0aHJlYWRfa2lsbC5jOjQ0DQojMSAgX19wdGhyZWFkX2tpbGxfaW50ZXJuYWwgKHNpZ25vPTYs IHRocmVhZGlkPTE0MDA0NDg2MjAzMTY4MCkgYXQKLi9ucHRsL3B0aHJlYWRfa2lsbC5jOjc4DQoj MiAgX19HSV9fX3B0aHJlYWRfa2lsbCAodGhyZWFkaWQ9MTQwMDQ0ODYyMDMxNjgwLCBzaWdubz1z aWdub0BlbnRyeT02KSBhdAouL25wdGwvcHRocmVhZF9raWxsLmM6ODkNCiMzICAweDAwMDA3ZjVl YmI5MGU0NzYgaW4gX19HSV9yYWlzZSAoc2lnPXNpZ0BlbnRyeT02KSBhdAouLi9zeXNkZXBzL3Bv c2l4L3JhaXNlLmM6MjYNCiM0ICAweDAwMDA3ZjVlYmI4ZjQ3ZjMgaW4gX19HSV9hYm9ydCAoKSBh dCAuL3N0ZGxpYi9hYm9ydC5jOjc5DQojNSAgMHgwMDAwNTYyZmFmMTcyY2Y2IGluIEV4Y2VwdGlv bmFsQ29uZGl0aW9uIChjb25kaXRpb25OYW1lPTB4NTYyZmFmMzQ2NzI1CiJydGUtPnJ0ZWtpbmQg PT0gUlRFX1ZBTFVFUyIsIA0KICAgIGVycm9yVHlwZT0weDU2MmZhZjM0NjJiMyAiRmFpbGVkQXNz ZXJ0aW9uIiwgZmlsZU5hbWU9MHg1NjJmYWYzNDYzNGMKInJld3JpdGVIYW5kbGVyLmMiLCBsaW5l TnVtYmVyPTE2MDApDQogICAgYXQgYXNzZXJ0LmM6NjkNCiM2ICAweDAwMDA1NjJmYWVmMmM5MzYg aW4gcmV3cml0ZVZhbHVlc1JURVRvTnVsbHMgKHBhcnNldHJlZT0weDU2MmZiMTIzMjAyOCwKcnRl PTB4NTYyZmIxMzAwMmYwKQ0KICAgIGF0IHJld3JpdGVIYW5kbGVyLmM6MTYwMA0KIzcgIDB4MDAw MDU2MmZhZWYzMGJlMSBpbiBSZXdyaXRlUXVlcnkgKHBhcnNldHJlZT0weDU2MmZiMTIzMjE0MCwK cmV3cml0ZV9ldmVudHM9MHgwLCBvcmlnX3J0X2xlbmd0aD0wKQ0KICAgIGF0IHJld3JpdGVIYW5k bGVyLmM6Mzg3OA0KIzggIDB4MDAwMDU2MmZhZWYzMTZkYSBpbiBRdWVyeVJld3JpdGUgKHBhcnNl dHJlZT0weDU2MmZiMTIzMjE0MCkgYXQKcmV3cml0ZUhhbmRsZXIuYzo0MTY4DQojOSAgMHgwMDAw NTYyZmFlZjlkYzYxIGluIHBnX3Jld3JpdGVfcXVlcnkgKHF1ZXJ5PTB4NTYyZmIxMjMyMTQwKSBh dApwb3N0Z3Jlcy5jOjc5Mg0KIzEwIDB4MDAwMDU2MmZhZWY5ZGEyZSBpbiBwZ19hbmFseXplX2Fu ZF9yZXdyaXRlX2ZpeGVkcGFyYW1zCihwYXJzZXRyZWU9MHg1NjJmYjEyMzFmOTgsIA0KICAgIHF1 ZXJ5X3N0cmluZz0weDU2MmZiMTIzMTFiMCAiSU5TRVJUIElOVE8gdiBWQUxVRVMgKDAsIERFRkFV TFQpLCAoMSwKREVGQVVMVCk7IiwgcGFyYW1UeXBlcz0weDAsIG51bVBhcmFtcz0wLCANCiAgICBx dWVyeUVudj0weDApIGF0IHBvc3RncmVzLmM6NjY2DQojMTEgMHgwMDAwNTYyZmFlZjllMjY5IGlu IGV4ZWNfc2ltcGxlX3F1ZXJ5ICgNCiAgICBxdWVyeV9zdHJpbmc9MHg1NjJmYjEyMzExYjAgIklO U0VSVCBJTlRPIHYgVkFMVUVTICgwLCBERUZBVUxUKSwgKDEsCkRFRkFVTFQpOyIpIGF0IHBvc3Rn cmVzLmM6MTE2Ng0KIzEyIDB4MDAwMDU2MmZhZWZhMzMzOSBpbiBQb3N0Z3Jlc01haW4gKGRibmFt ZT0weDU2MmZiMTI1ZDY1OCAicmVncmVzc2lvbiIsCnVzZXJuYW1lPTB4NTYyZmIxMjVkNjM4ICJs YXciKQ0KICAgIGF0IHBvc3RncmVzLmM6NDU5Mw0KIzEzIDB4MDAwMDU2MmZhZWVjOGFmYiBpbiBC YWNrZW5kUnVuIChwb3J0PTB4NTYyZmIxMjU0ZDcwKSBhdApwb3N0bWFzdGVyLmM6NDUxMQ0KIzE0 IDB4MDAwMDU2MmZhZWVjODM4MiBpbiBCYWNrZW5kU3RhcnR1cCAocG9ydD0weDU2MmZiMTI1NGQ3 MCkgYXQKcG9zdG1hc3Rlci5jOjQyMzkNCiMxNSAweDAwMDA1NjJmYWVlYzQzMGYgaW4gU2VydmVy TG9vcCAoKSBhdCBwb3N0bWFzdGVyLmM6MTgwNg0KIzE2IDB4MDAwMDU2MmZhZWVjM2E2YyBpbiBQ b3N0bWFzdGVyTWFpbiAoYXJnYz0zLCBhcmd2PTB4NTYyZmIxMjJjNjcwKSBhdApwb3N0bWFzdGVy LmM6MTQ3OA0KIzE3IDB4MDAwMDU2MmZhZWRiNzlhZCBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9MHg1 NjJmYjEyMmM2NzApIGF0IG1haW4uYzoyMDINCg0KV2l0aG91dCBhc3NlcnRzIGVuYWJsZWQgSSBn ZXQ6DQpFUlJPUjogIHVucmVjb2duaXplZCBub2RlIHR5cGU6IDE0OA0KU1RBVEVNRU5UOiAgSU5T RVJUIElOVE8gdiBWQUxVRVMgKDAsIERFRkFVTFQpLCAoMSwgREVGQVVMVCk7DQoNCkl0IGxvb2tz IGxpa2UgdGhpcyBpcyBvcmlnaW5hdGVkIGZyb20gdGhlIGNvbW1pdCA0MTUzMWU0MmQNCnRoYXQg d2FzIHByZXBhcmVkIG9ubHkgZm9yICJBTFNPIElOU0VSVCAuLi4gVkFMVUVTIC4uLiIgKGJlZm9y ZSBpdA0KSU5TRVJUIFNFTEVDVCB3b3JrZWQganVzdCBhcyBpbmNvcnJlY3RseSBhcyBJTlNFUlQg VkFMVUVTKSwNCmFuZCB0aGUgZm9sbG93aW5nIGNvbW1pdHMgKGVkNDY1M2RiOCwgIGI4ZjI2ODdm ZCwgMjYwNTY0M2EpLA0Kd2hpY2ggbWFzc2FnZWQgdGhhdCBjb2RlIGRpZG4ndCBmaXggdGhpbmdz IGZvciB0aGlzIHNjZW5hcmlvIHlldC4KCg== --===============8597609052680340484==--