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 1pID7C-0008Eq-H0 for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 18:24:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pID7B-0002vf-Dl for pgsql-committers@arkaria.postgresql.org; Wed, 18 Jan 2023 18:24:49 +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 1pID7B-0002vW-6Z for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 18:24:49 +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 1pID78-0001ak-Is for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 18:24:48 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pID78-0006Bf-63 for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 18:24:46 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pID77-004KBV-9p for pgsql-committers@lists.postgresql.org; Wed, 18 Jan 2023 18:24:45 +0000 Content-Type: multipart/mixed; boundary="===============7172588297315037177==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Get rid of the "new" and "old" entries in a view's rangetable. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 18 Jan 2023 18:24:45 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7172588297315037177== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 R2V0IHJpZCBvZiB0aGUgIm5ldyIgYW5kICJvbGQiIGVudHJpZXMgaW4gYSB2aWV3J3MgcmFuZ2V0 YWJsZS4KClRoZSBydWxlIHN5c3RlbSBuZWVkcyAib2xkIiBhbmQvb3IgIm5ldyIgcHNldWRvLVJU RXMgaW4gcnVsZSBhY3Rpb25zCnRoYXQgYXJlIE9OIElOU0VSVC9VUERBVEUvREVMRVRFLiAgSGlz dG9yaWNhbGx5IGl0J3MgcHV0IHN1Y2ggZW50cmllcwppbnRvIHRoZSBPTiBTRUxFQ1QgcnVsZXMg b2Ygdmlld3MgYXMgd2VsbCwgYnV0IHRob3NlIGFyZSByZWFsbHkgcXVpdGUKdmVzdGlnaWFsLiAg VGhlIG9ubHkgdGhpbmcgd2UndmUgdXNlZCB0aGVtIGZvciBpcyB0byBjYXJyeSB0aGUKdmlldydz IHJlbGlkIGZvcndhcmQgdG8gQWNxdWlyZUV4ZWN1dG9yTG9ja3MgKHNvIHRoYXQgd2UgY2FuCnJl LWxvY2sgdGhlIHZpZXcgdG8gdmVyaWZ5IGl0IGhhc24ndCBjaGFuZ2VkIGJlZm9yZSByZS11c2lu ZyBhIHBsYW4pCmFuZCB0byBjYXJyeSBpdHMgcmVsaWQgYW5kIHBlcm1pc3Npb25zIGRhdGEgZm9y d2FyZCB0byBleGVjdXRpb24tdGltZQpwZXJtaXNzaW9ucyBjaGVja3MuICBXaGF0IHdlIGNhbiBk byBpbnN0ZWFkIG9mIHRoYXQgaXMgdG8gcmV0YWluCnRoZXNlIGZpZWxkcyBvZiB0aGUgUlRFX1JF TEFUSU9OIFJURSBmb3IgdGhlIHZpZXcgZXZlbiBhZnRlciB3ZQpjb252ZXJ0IGl0IHRvIGFuIFJU RV9TVUJRVUVSWSBSVEUuICBUaGlzIHJlcXVpcmVzIGEgdGlueSBhbW91bnQgb2YKZXh0cmEgY29t cGxpY2F0aW9uIGluIHRoZSBwbGFubmVyIGFuZCBBY3F1aXJlRXhlY3V0b3JMb2NrcywgYnV0IG9u CnRoZSBvdGhlciBoYW5kIHdlIGNhbiBnZXQgcmlkIG9mIHRoZSBsb2dpYyB0aGF0IG1vdmVzIHRo YXQgZGF0YSBmcm9tCm9uZSBwbGFjZSB0byBhbm90aGVyLgoKVGhlIHByaW5jaXBhbCBpbW1lZGlh dGUgYmVuZWZpdCBvZiBkb2luZyB0aGlzLCBhc2lkZSBmcm9tIGEgc21hbGwKc2F2aW5nIGluIHRo ZSBwZ19yZXdyaXRlIGRhdGEgZm9yIHZpZXdzLCBpcyB0aGF0IHRoZXNlIHBzZXVkby1SVEVzCm5v IGxvbmdlciB0cmlnZ2VyIHJ1bGV1dGlscy5jJ3MgaGV1cmlzdGljIGFib3V0IHF1YWxpZnlpbmcg dmFyaWFibGUKbmFtZXMgd2hlbiB0aGUgcmFuZ2V0YWJsZSdzIGxlbmd0aCBpcyBtb3JlIHRoYW4g MS4gIFRoYXQgcmVzdWx0cwppbiBxdWl0ZSBhIG51bWJlciBvZiBzbWFsbCBzaW1wbGlmaWNhdGlv bnMgaW4gcmVncmVzc2lvbiB0ZXN0IG91dHB1dHMsCndoaWNoIGFyZSBhbGwgdG8gdGhlIGdvb2Qg SU1PLgoKQnVtcCBjYXR2ZXJzaW9uIGJlY2F1c2Ugd2UgbmVlZCB0byBkdW1wIGEgZmV3IG1vcmUg ZmllbGRzIG9mClJURV9TVUJRVUVSWSBSVEVzLiAgV2hpbGUgdGhvc2Ugd2lsbCBhbHdheXMgYmUg emVyb2VzIGFueXdheSBpbgpzdG9yZWQgcnVsZXMgKGJlY2F1c2Ugd2UnZCBuZXZlciBwb3B1bGF0 ZSB0aGVtIHVudGlsIHF1ZXJ5IHJld3JpdGUpCnRoZXkgYXJlIHVzZWZ1bCBmb3IgZGVidWdnaW5n LCBhbmQgaXQgc2VlbXMgbGlrZSB3ZSdkIGJldHRlciBtYWtlCnN1cmUgdG8gdHJhbnNtaXQgc3Vj aCBSVEVzIGFjY3VyYXRlbHkgaW4gcGxhbnMgc2VudCB0byBwYXJhbGxlbAp3b3JrZXJzLiAgSSBk b24ndCB0aGluayB0aGUgZXhlY3V0b3IgYWN0dWFsbHkgZXhhbWluZXMgdGhlc2UgZmllbGRzCmFm dGVyIHN0YXJ0dXAsIGJ1dCBzb21lZGF5IGl0IG1pZ2h0LgoKVGhpcyBpcyBhIHNlY29uZCBhdHRl bXB0IGF0IGNvbW1pdHRpbmcgMWI0ZDI4MGVhLiAgVGhlIGRpZmZlcmVuY2UKZnJvbSB0aGUgZmly c3QgdGltZSBpcyB0aGF0IG5vdyB3ZSBjYW4gYWRkIHNvbWUgZmlsdGVyaW5nIHJ1bGVzIHRvCkFk anVzdFVwZ3JhZGUucG0gdG8gYWxsb3cgY3Jvc3MtdmVyc2lvbiB1cGdyYWRlIHRlc3RpbmcgdG8g cGFzcwpkZXNwaXRlIGFsbCB0aGUgY29zbWV0aWMgY2hhbmdlcyBpbiBDUkVBVEUgVklFVyBvdXRw dXRzLgoKQW1pdCBMYW5nb3RlIChmaWx0ZXJpbmcgcnVsZXMgYnkgbWUpCgpEaXNjdXNzaW9uOiBo dHRwczovL3Bvc3Rnci5lcy9tL0NBK0hpd3FFZjdnUE40SG4rTG9aNHRQMnFfUXQ3bjN2dzctNmZK S09mOTJ0U0VuWDZHZ0BtYWlsLmdtYWlsLmNvbQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tLzg5MTUyMS4xNjczNjU3Mjk2QHNzcy5wZ2gucGEudXMKCkJyYW5jaAotLS0tLS0KbWFzdGVy CgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlm Zi80N2JiOWRiNzU5OTYyMzJlYTcxZmMxZTE4ODhmZmIwZTcwNTc5YjU0CgpNb2RpZmllZCBGaWxl cwotLS0tLS0tLS0tLS0tLQpjb250cmliL3Bvc3RncmVzX2Zkdy9leHBlY3RlZC9wb3N0Z3Jlc19m ZHcub3V0ICAgfCAgMTYgKy0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvbG9ja2NtZHMuYyAgICAgICAg ICAgICAgICAgIHwgICA5IC0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdmlldy5jICAgICAgICAgICAg ICAgICAgICAgIHwgMTA3IC0tLS0Kc3JjL2JhY2tlbmQvbm9kZXMvb3V0ZnVuY3MuYyAgICAgICAg ICAgICAgICAgICAgIHwgICA3ICstCnNyYy9iYWNrZW5kL25vZGVzL3JlYWRmdW5jcy5jICAgICAg ICAgICAgICAgICAgICB8ICAgNyArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zZXRyZWZz LmMgICAgICAgICAgICAgfCAgMjYgKy0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3JlbGF0aW9u LmMgICAgICAgICAgICAgIHwgICAyICstCnNyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0ZURlZmlu ZS5jICAgICAgICAgICAgICB8ICAgNyAtCnNyYy9iYWNrZW5kL3Jld3JpdGUvcmV3cml0ZUhhbmRs ZXIuYyAgICAgICAgICAgICB8ICAzOCArLQpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9wbGFuY2Fj aGUuYyAgICAgICAgICAgICAgfCAgIDMgKy0Kc3JjL2Jpbi9wZ19kdW1wL3QvMDAyX3BnX2R1bXAu cGwgICAgICAgICAgICAgICAgIHwgIDEyICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lv bi5oICAgICAgICAgICAgICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9ub2Rlcy9wYXJzZW5vZGVz LmggICAgICAgICAgICAgICAgICAgfCAgMTggKy0Kc3JjL3Rlc3QvcGVybC9Qb3N0Z3JlU1FML1Rl c3QvQWRqdXN0VXBncmFkZS5wbSAgIHwgMTMzICsrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9hZ2dyZWdhdGVzLm91dCAgICAgICAgIHwgIDI2ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvYWx0ZXJfdGFibGUub3V0ICAgICAgICB8ICAxNiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL2NvbGxhdGUuaWN1LnV0Zjgub3V0ICAgfCAgMjQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9jb2xsYXRlLmxpbnV4LnV0Zjgub3V0IHwgIDI0ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvY29sbGF0ZS5vdXQgICAgICAgICAgICB8ICAyNiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL2NvbXByZXNzaW9uLm91dCAgICAgICAgfCAgIDQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9jcmVhdGVfdmlldy5vdXQgICAgICAgIHwgMjIyICsrKy0tLS0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9leHByZXNzaW9ucy5vdXQgICAgICAgIHwgIDI0ICstCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvZ3JvdXBpbmdzZXRzLm91dCAgICAgICB8ICAyMCArLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL2xpbWl0Lm91dCAgICAgICAgICAgICAgfCAgMjQgKy0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC9tYXR2aWV3Lm91dCAgICAgICAgICAgIHwgIDI0ICstCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvcG9seW1vcnBoaXNtLm91dCAgICAgICB8ICAgOCArLQpzcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL3JhbmdlZnVuY3Mub3V0ICAgICAgICAgfCAgMzQgKy0Kc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9ydWxlcy5vdXQgICAgICAgICAgICAgIHwgNzQ4ICsrKysrKysr KysrLS0tLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdGFibGVzYW1wbGUub3V0 ICAgICAgICB8ICAgNCArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3RyaWdnZXJzLm91dCAg ICAgICAgICAgfCAgIDQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC91cGRhdGFibGVfdmll d3Mub3V0ICAgIHwgIDc4ICstLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3dpbmRvdy5vdXQg ICAgICAgICAgICAgfCAgNTYgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC93aXRoLm91dCAg ICAgICAgICAgICAgIHwgIDMyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQveG1sLm91dCAg ICAgICAgICAgICAgICB8ICAgNiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3htbF8yLm91 dCAgICAgICAgICAgICAgfCAgIDYgKy0KMzUgZmlsZXMgY2hhbmdlZCwgOTA3IGluc2VydGlvbnMo KyksIDg5MCBkZWxldGlvbnMoLSkKCg== --===============7172588297315037177==--