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 1o3nKB-0003dF-7S for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jun 2022 23:30:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o3nK8-00029o-He for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jun 2022 23:30:20 +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 1o3n2c-0000V4-Bw for pgsql-bugs@lists.postgresql.org; Tue, 21 Jun 2022 23:12:14 +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 1o3n2U-00017A-Gu for pgsql-bugs@lists.postgresql.org; Tue, 21 Jun 2022 23:12:13 +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=1WLdUakAlMCc+QJZfQ7v/o2wnLXHWvbPvDpWpW7aYhI=; b=Tmczvh/2Y65PU0MvDtz9ZaZ7Ts 1znklFn1f1KKw/N78S+wD9KSpAngh64ckTHkEjA4bCz/VGnsGXkME41Xm4gfF3ZLTb0N/rjxX3fTM ta6wgXziQtQUsy3kk2EiCF7puLB8XHTer5aURa/2W+W4s/mMKMLKMywGI7b0qia1GTVQOHi9vrYjF dCUEDpM39kwddfSJCwoQ1OLSXe0YMjUibXStuzialA00e6IQtQEpJqX+KmItC5zjyjyZK3K4KD8f6 WEzUHcK0N4WOZS9GDGYCvrFkTIgnQSdryPjRqcKOe+jJuZn30sXmsVJr57ZMdCTDZp8UdwJqfjHZX DAZ0c9Xw==; 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 1o3n2T-0003pQ-F1 for pgsql-bugs@lists.postgresql.org; Tue, 21 Jun 2022 23:12: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 1o3n2R-004QB4-0u for pgsql-bugs@lists.postgresql.org; Tue, 21 Jun 2022 23:12:02 +0000 Content-Type: multipart/mixed; boundary="===============7846606906188433037==" MIME-Version: 1.0 Subject: BUG #17525: Range partition by date won't allow the use of a date that is the upper bound To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: allen.sutton@valocityglobal.com Reply-To: allen.sutton@valocityglobal.com, pgsql-bugs@lists.postgresql.org Date: Tue, 21 Jun 2022 23:11:53 +0000 Message-ID: <17525-ffa3a5fe34f8c6f4@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 --===============7846606906188433037== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzUyNQpMb2dnZWQgYnk6ICAgICAgICAgIEFsbGVuIFN1dHRvbgpFbWFp bCBhZGRyZXNzOiAgICAgIGFsbGVuLnN1dHRvbkB2YWxvY2l0eWdsb2JhbC5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxNC40Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0TFRTCkRlc2Ny aXB0aW9uOiAgICAgICAgCgpJIGhhdmUgYSB0YWJsZSB0aGF0IEkgaGF2ZSBwYXJ0aXRpb25lZCBi eSBhIGZpZWxkIGVzdF9kYXRlIChkYXRlKS4NCg0KQ1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMg YXZtLmF2bV9oaXN0b3J5X3BhcnQNCigNCiAgICBtb2RlbF90eXBlIGNoYXJhY3RlciB2YXJ5aW5n KDQpIENPTExBVEUgcGdfY2F0YWxvZy4iZGVmYXVsdCIsDQogICAgbW9kZWxfaWQgaW50ZWdlciwN CiAgICBlc3RfZGF0ZSBkYXRlIE5PVCBOVUxMLA0KICAgIGFkZHJlc3NfaWQgaW50ZWdlciwNCiAg ICBlc3QgaW50ZWdlciwNCiAgICBjb25mIG51bWVyaWMoOCw0KSwNCiAgICBjb21wc191c2VkIGJp Z2ludCwNCiAgICBsYXN0IHNtYWxsaW50IERFRkFVTFQgMCwNCiAgICBlc3RfaWQgaW50ZWdlciBO T1QgTlVMTCBERUZBVUxUCm5leHR2YWwoJ2F2bS5hdm1faGlzdG9yeV9wYXJ0X2VzdF9pZF9zZXEx Jzo6cmVnY2xhc3MpLA0KICAgIGVzdF9zbW9vdGhlZCBpbnRlZ2VyLA0KICAgIGRpcGlkIGNoYXJh Y3RlciB2YXJ5aW5nKDIwKSBDT0xMQVRFIHBnX2NhdGFsb2cuImRlZmF1bHQiLA0KICAgIGZzZCBu dW1lcmljKDQsMSkNCikgUEFSVElUSU9OIEJZIFJBTkdFIChlc3RfZGF0ZSk7DQoNClRoZSBwYXJ0 aXRpb25zIG9mIHRoaXMgdGFibGUgYXJlIGNyZWF0ZWQgd2l0aCBhIHJhbmdlIG9mIGEgbW9udGgu DQoNCmUuZy4gQ1JFQVRFIFRBQkxFIGF2bS5hdm1faGlzdG9yeV8yMDE3MDQgUEFSVElUSU9OIE9G IGF2bS5hdm1faGlzdG9yeV9wYXJ0DQogICAgRk9SIFZBTFVFUyBGUk9NICgnMjAxNy0wNC0wMScp IFRPICgnMjAxNy0wNC0zMCcpOw0KDQpUaGlzIHNlZW1zIHRvIGJlIGNhdXNpbmcgaXNzdWVzIGlu IHR3byB3YXlzOiAtDQoxLiBXaGVuIEkgcHJlcGFyZSBhIHRhYmxlIGFuZCB0aGVuIGFkZCBpdCBh cyBhIHBhcnRpdGlvbiB3aXRoIGEgZGF0ZSByYW5nZQphbmQgZXN0X2RhdGUgaW4gcm93cyBlcXVh bCB0byB0aGUgdXBwZXIgYm91bmQgb2YgdGhlIHJhbmdlLCBQb3N0Z3JlcyBnaXZlcwptZSBhbiBl cnJvciB0aGF0IGl0IGNhbid0IGZpbmQgYSBwYXJ0aXRpb24gZm9yIHRoZSBkYXRlDQoyLiBXaGVu IEkgdHJ5IHVwZGF0ZSBhIHJvdyBhbmQgc2V0IHRoZSB2YWx1ZSBvZiBlc3RfZGF0ZSB0byB0aGUg dXBwZXIgcmFuZ2UsCkkgZ2V0IGFuIHVwZGF0ZSBlcnJvciBzdWNoIGFzDQoNCkVSUk9SOiAgbmV3 IHJvdyBmb3IgcmVsYXRpb24gImF2bV9oaXN0b3J5XzIwMTcwNCIgdmlvbGF0ZXMgcGFydGl0aW9u CmNvbnN0cmFpbnQNCkRFVEFJTDogIEZhaWxpbmcgcm93IGNvbnRhaW5zIChBLCAxMSwgMjAxNy0w NC0zMCwgNDY4NDYsIDEyNzAwMDAsIDAuMjY0NywgNywKMCwgMjY1NjM1MjMsIDEyNDYwMDAsIE5a ODIwNDcxMDUsIDM5LjkpLg0KU1FMIHN0YXRlOiAyMzUxNA0KDQpJIG5lZWQgYXNzaXN0YW5jZSB0 byB3b3JrIG91dCB3aGF0IEkgaGF2ZSBkb25lIHdyb25nIGlmIGFueXRoaW5nIGFuZCBob3cgdG8K cmVzb2x2ZSB0aGlzIGlzc3VlCgo= --===============7846606906188433037==--