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 1sqUe5-00AADw-SJ for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 09:37:18 +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 1sqUe5-008EQE-G9 for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 09:37:17 +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 1sqUe5-008EGn-7Y for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 09:37:17 +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 1sqUdx-001cpN-2a for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 09:37:16 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqUdv-005E6j-OT for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 09:37:07 +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 1sqUdu-001Uag-U2 for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 09:37:07 +0000 Content-Type: multipart/mixed; boundary="===============1276190646288897729==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add temporal PRIMARY KEY and UNIQUE constraints X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 17 Sep 2024 09:37:07 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1276190646288897729== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHRlbXBvcmFsIFBSSU1BUlkgS0VZIGFuZCBVTklRVUUgY29uc3RyYWludHMKCkFkZCBXSVRI T1VUIE9WRVJMQVBTIGNsYXVzZSB0byBQUklNQVJZIEtFWSBhbmQgVU5JUVVFIGNvbnN0cmFpbnRz LgpUaGVzZSBhcmUgYmFja2VkIGJ5IEdpU1QgaW5kZXhlcyBpbnN0ZWFkIG9mIEItdHJlZSBpbmRl eGVzLCBzaW5jZSB0aGV5CmFyZSBlc3NlbnRpYWxseSBleGNsdXNpb24gY29uc3RyYWludHMgd2l0 aCA9IGZvciB0aGUgc2NhbGFyIHBhcnRzIG9mCnRoZSBrZXkgYW5kICYmIGZvciB0aGUgdGVtcG9y YWwgcGFydC4KCihwcmV2aW91c2x5IGNvbW1pdHRlZCBhcyA0NmEwY2Q0Y2VmYiwgcmV2ZXJ0ZWQg YnkgNDZhMGNkNGNlZmI7IHRoZSBuZXcKcGFydCBpcyB0aGlzOikKCkJlY2F1c2UgJ2VtcHR5JyAm JiAnZW1wdHknIGlzIGZhbHNlLCB0aGUgdGVtcG9yYWwgUEsvVVEgY29uc3RyYWludAphbGxvd2Vk IGR1cGxpY2F0ZXMsIHdoaWNoIGlzIGNvbmZ1c2luZyB0byB1c2VycyBhbmQgYnJlYWtzIGludGVy bmFsCmV4cGVjdGF0aW9ucy4gIEZvciBpbnN0YW5jZSwgd2hlbiBHUk9VUCBCWSBjaGVja3MgZnVu Y3Rpb25hbApkZXBlbmRlbmNpZXMgb24gdGhlIFBLLCBpdCBhbGxvd3Mgc2VsZWN0aW5nIG90aGVy IGNvbHVtbnMgZnJvbSB0aGUKdGFibGUsIGJ1dCBpbiB0aGUgcHJlc2VuY2Ugb2YgZHVwbGljYXRl IGtleXMgeW91IGNvdWxkIGdldCB0aGUgdmFsdWUKZnJvbSBhbnkgb2YgdGhlaXIgcm93cy4gIFNv IHdlIG5lZWQgdG8gZm9yYmlkIGVtcHRpZXMuCgpUaGlzIGFsbCBtZWFucyB0aGF0IGF0IHRoZSBt b21lbnQgd2UgY2FuIG9ubHkgc3VwcG9ydCByYW5nZXMgYW5kCm11bHRpcmFuZ2VzIGZvciB0ZW1w b3JhbCBQSy9VUXMsIHVubGlrZSB0aGUgb3JpZ2luYWwgcGF0Y2ggKGFib3ZlKS4KRG9jdW1lbnRh dGlvbiBhbmQgdGVzdHMgZm9yIHRoaXMgYXJlIGFkZGVkLiAgQnV0IHRoaXMgY291bGQKY29uY2Vp dmFibHkgYmUgZXh0ZW5kZWQgYnkgaW50cm9kdWNpbmcgc29tZSBtb3JlIGdlbmVyYWwgc3VwcG9y dCBmb3IKdGhlIG5vdGlvbiBvZiAiZW1wdHkiIGZvciBvdGhlciB0eXBlcy4KCkF1dGhvcjogUGF1 bCBBLiBKdW5nd2lydGggPHBqQGlsbHVtaW5hdGVkY29tcHV0aW5nLmNvbT4KUmV2aWV3ZWQtYnk6 IFBldGVyIEVpc2VudHJhdXQgPHBldGVyQGVpc2VudHJhdXQub3JnPgpSZXZpZXdlZC1ieTogamlh biBoZSA8amlhbi51bml2ZXJzYWxpdHlAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3d3 dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQvQ0ErcmVueVVBcEhnU1pGOS1uZC1hMCtP UEdoYXJMUUxPPW1ESGNZNF9xUTArbm9DVVZnQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0t Cm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2Nv bW1pdGRpZmYvZmMwNDM4YjRlODA1MzU0MTlhNGU1NGRiYTg3NjQyY2RmODRkZWZkYQoKTW9kaWZp ZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9idHJlZV9naXN0L01ha2VmaWxlICAgICAg ICAgICAgICAgICAgICAgIHwgICAgMiArLQpjb250cmliL2J0cmVlX2dpc3QvZXhwZWN0ZWQvd2l0 aG91dF9vdmVybGFwcy5vdXQgfCAgIDQ0ICsKY29udHJpYi9idHJlZV9naXN0L21lc29uLmJ1aWxk ICAgICAgICAgICAgICAgICAgIHwgICAgMSArCmNvbnRyaWIvYnRyZWVfZ2lzdC9zcWwvd2l0aG91 dF9vdmVybGFwcy5zcWwgICAgICB8ICAgMjUgKwpkb2Mvc3JjL3NnbWwvY2F0YWxvZ3Muc2dtbCAg ICAgICAgICAgICAgICAgICAgICAgfCAgIDEwICsKZG9jL3NyYy9zZ21sL2dpc3Quc2dtbCAgICAg ICAgICAgICAgICAgICAgICAgICAgIHwgICAxMSArLQpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90 YWJsZS5zZ21sICAgICAgICAgICAgICAgfCAgIDM5ICstCnNyYy9iYWNrZW5kL2FjY2Vzcy9naXN0 L2dpc3R1dGlsLmMgICAgICAgICAgICAgICB8ICAgMjkgKwpzcmMvYmFja2VuZC9jYXRhbG9nL2hl YXAuYyAgICAgICAgICAgICAgICAgICAgICAgfCAgICAxICsKc3JjL2JhY2tlbmQvY2F0YWxvZy9p bmRleC5jICAgICAgICAgICAgICAgICAgICAgIHwgICAxNCArLQpzcmMvYmFja2VuZC9jYXRhbG9n L3BnX2NvbnN0cmFpbnQuYyAgICAgICAgICAgICAgfCAgICAyICsKc3JjL2JhY2tlbmQvY29tbWFu ZHMvaW5kZXhjbWRzLmMgICAgICAgICAgICAgICAgIHwgIDE2MiArKy0Kc3JjL2JhY2tlbmQvY29t bWFuZHMvdGFibGVjbWRzLmMgICAgICAgICAgICAgICAgIHwgICAgNiArLQpzcmMvYmFja2VuZC9j b21tYW5kcy90cmlnZ2VyLmMgICAgICAgICAgICAgICAgICAgfCAgICAxICsKc3JjL2JhY2tlbmQv Y29tbWFuZHMvdHlwZWNtZHMuYyAgICAgICAgICAgICAgICAgIHwgICAgMiArCnNyYy9iYWNrZW5k L2V4ZWN1dG9yL2V4ZWNJbmRleGluZy5jICAgICAgICAgICAgICB8ICAgNjYgKy0Kc3JjL2JhY2tl bmQvbm9kZXMvbWFrZWZ1bmNzLmMgICAgICAgICAgICAgICAgICAgIHwgICAgNCArLQpzcmMvYmFj a2VuZC9vcHRpbWl6ZXIvdXRpbC9wbGFuY2F0LmMgICAgICAgICAgICAgfCAgICA5ICstCnNyYy9i YWNrZW5kL3BhcnNlci9ncmFtLnkgICAgICAgICAgICAgICAgICAgICAgICB8ICAgMjkgKy0Kc3Jj L2JhY2tlbmQvcGFyc2VyL3BhcnNlX3V0aWxjbWQuYyAgICAgICAgICAgICAgIHwgICA4MCArLQpz cmMvYmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMgICAgICAgICAgICAgICAgfCAgICAyICsK c3JjL2JhY2tlbmQvdXRpbHMvY2FjaGUvcmVsY2FjaGUuYyAgICAgICAgICAgICAgIHwgICAxOCAr LQpzcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5jICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDE2 ICstCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1wLmggICAgICAgICAgICAgICAgICAgICAgICB8ICAg IDEgKwpzcmMvYmluL3BnX2R1bXAvdC8wMDJfcGdfZHVtcC5wbCAgICAgICAgICAgICAgICAgfCAg IDM2ICsKc3JjL2Jpbi9wc3FsL2Rlc2NyaWJlLmMgICAgICAgICAgICAgICAgICAgICAgICAgIHwg ICAxMiArLQpzcmMvaW5jbHVkZS9hY2Nlc3MvZ2lzdC5oICAgICAgICAgICAgICAgICAgICAgICAg fCAgICAzICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgICAgICAg IHwgICAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2luZGV4LmggICAgICAgICAgICAgICAgICAg ICAgfCAgICAxICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19jb25zdHJhaW50LmggICAgICAgICAg ICAgIHwgICAxMCArLQpzcmMvaW5jbHVkZS9jb21tYW5kcy9kZWZyZW0uaCAgICAgICAgICAgICAg ICAgICAgfCAgICA2ICstCnNyYy9pbmNsdWRlL25vZGVzL2V4ZWNub2Rlcy5oICAgICAgICAgICAg ICAgICAgICB8ICAgIDEgKwpzcmMvaW5jbHVkZS9ub2Rlcy9tYWtlZnVuY3MuaCAgICAgICAgICAg ICAgICAgICAgfCAgICAyICstCnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9kZXMuaCAgICAgICAg ICAgICAgICAgICB8ICAgIDIgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3dpdGhvdXRfb3Zl cmxhcHMub3V0ICAgfCAxMzM2ICsrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVz cy9wYXJhbGxlbF9zY2hlZHVsZSAgICAgICAgICAgICAgIHwgICAgMiArLQpzcmMvdGVzdC9yZWdy ZXNzL3NxbC93aXRob3V0X292ZXJsYXBzLnNxbCAgICAgICAgfCAgOTIzICsrKysrKysrKysrKysr KwozNyBmaWxlcyBjaGFuZ2VkLCAyODQ4IGluc2VydGlvbnMoKyksIDYyIGRlbGV0aW9ucygtKQoK --===============1276190646288897729==--