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 1t9Oet-009oxy-HL for pgsql-committers@arkaria.postgresql.org; Fri, 08 Nov 2024 13:04:14 +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 1t9Oeq-0096vi-5r for pgsql-committers@arkaria.postgresql.org; Fri, 08 Nov 2024 13:04:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t9Oep-0096vZ-QV for pgsql-committers@lists.postgresql.org; Fri, 08 Nov 2024 13:04:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t9Oen-000o45-BE for pgsql-committers@lists.postgresql.org; Fri, 08 Nov 2024 13:04:11 +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 1t9Oel-002SDQ-Mq for pgsql-committers@lists.postgresql.org; Fri, 08 Nov 2024 13:04:08 +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 1t9Oel-000p5S-G2 for pgsql-committers@lists.postgresql.org; Fri, 08 Nov 2024 13:04:07 +0000 Content-Type: multipart/mixed; boundary="===============1271984662087092873==" MIME-Version: 1.0 From: =?utf-8?q?=C3=81lvaro_Herrera?= To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add pg_constraint rows for not-null constraints X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 08 Nov 2024 13:04:07 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1271984662087092873== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHBnX2NvbnN0cmFpbnQgcm93cyBmb3Igbm90LW51bGwgY29uc3RyYWludHMKCldlIG5vdyBj cmVhdGUgY29udHlwZT0nbicgcGdfY29uc3RyYWludCByb3dzIGZvciBub3QtbnVsbCBjb25zdHJh aW50cyBvbgp1c2VyIHRhYmxlcy4gIE9ubHkgb25lIHN1Y2ggY29uc3RyYWludCBpcyBhbGxvd2Vk IGZvciBhIGNvbHVtbi4KCldlIHByb3BhZ2F0ZSB0aGVzZSBjb25zdHJhaW50cyB0byBvdGhlciB0 YWJsZXMgZHVyaW5nIG9wZXJhdGlvbnMgc3VjaCBhcwphZGRpbmcgaW5oZXJpdGFuY2UgcmVsYXRp b25zaGlwcywgY3JlYXRpbmcgYW5kIGF0dGFjaGluZyBwYXJ0aXRpb25zIGFuZApjcmVhdGluZyB0 YWJsZXMgTElLRSBvdGhlciB0YWJsZXMuICBUaGVzZSByZWxhdGVkIGNvbnN0cmFpbnRzIG1vc3Rs eQpmb2xsb3cgdGhlIHdlbGwta25vd24gcnVsZXMgb2YgY29uaXNsb2NhbCBhbmQgY29uaW5oY291 bnQgdGhhdCB3ZSBoYXZlCmZvciBDSEVDSyBjb25zdHJhaW50cywgd2l0aCBzb21lIGFkYXB0YXRp b25zOiBmb3IgZXhhbXBsZSwgYXMgb3Bwb3NlZCB0bwpDSEVDSyBjb25zdHJhaW50cywgd2UgZG9u J3QgbWF0Y2ggbm90LW51bGwgb25lcyBieSBuYW1lIHdoZW4gZGVzY2VuZGluZwphIGhpZXJhcmNo eSB0byBhbHRlciBvciByZW1vdmUgaXQsIGluc3RlYWQgbWF0Y2hpbmcgYnkgdGhlIG5hbWUgb2Yg dGhlCmNvbHVtbiB0aGF0IHRoZXkgYXBwbHkgdG8uICBUaGlzIG1lYW5zIHdlIGRvbid0IHJlcXVp cmUgdGhlIGNvbnN0cmFpbnQKbmFtZXMgdG8gYmUgaWRlbnRpY2FsIGFjcm9zcyBhIGhpZXJhcmNo eS4KClRoZSBpbmhlcml0YW5jZSBzdGF0dXMgb2YgdGhlc2UgY29uc3RyYWludHMgY2FuIGJlIGNv bnRyb2xsZWQ6IG5vdyB3ZQpjYW4gYmUgc3VyZSB0aGF0IGlmIGEgcGFyZW50IHRhYmxlIGhhcyBv bmUsIHRoZW4gYWxsIGNoaWxkcmVuIHdpbGwgaGF2ZQppdCBhcyB3ZWxsLiAgVGhleSBjYW4gb3B0 aW9uYWxseSBiZSBtYXJrZWQgTk8gSU5IRVJJVCwgYW5kIHRoZW4gY2hpbGRyZW4KYXJlIGZyZWUg bm90IHRvIGhhdmUgb25lLiAgKFRoZXJlJ3MgY3VycmVudGx5IG5vIHN1cHBvcnQgZm9yIGFsdGVy aW5nIGEKTk8gSU5IRVJJVCBjb25zdHJhaW50IGludG8gaW5oZXJpdGluZyBkb3duIHRoZSBoaWVy YXJjaHksIGJ1dCB0aGF0J3MgYQpkZXNpcmFibGUgZnV0dXJlIGZlYXR1cmUuKQoKVGhpcyBhbHNv IG9wZW5zIHRoZSBkb29yIGZvciBoYXZpbmcgdGhlc2UgY29uc3RyYWludHMgYmUgbWFya2VkIE5P VApWQUxJRCwgYXMgd2VsbCBhcyBhbGxvd2luZyBVTklRVUUrTk9UIE5VTEwgdG8gYmUgdXNlZCBm b3IgZnVuY3Rpb25hbApkZXBlbmRlbmN5IGRldGVybWluYXRpb24sIGFzIGVudmlzaW9uZWQgYnkg Y29tbWl0IGU0OWFlOGQzYmM1OC4gIEl0J3MKbGlrZWx5IHBvc3NpYmxlIHRvIGFsbG93IERFRkVS UkFCTEUgY29uc3RyYWludHMgYXMgZm9sbG93dXAgd29yaywgYXMKd2VsbC4KCnBzcWwgc2hvd3Mg dGhlc2UgY29uc3RyYWludHMgaW4gXGQrLCB0aG91Z2ggd2UgbWF5IHdhbnQgdG8gcmVjb25zaWRl ciBpZgp0aGlzIHR1cm5zIG91dCB0byBiZSB0b28gbm9pc3kuICBFYXJsaWVyIHZlcnNpb25zIG9m IHRoaXMgcGF0Y2ggaGlkCmNvbnN0cmFpbnRzIHRoYXQgd2VyZSBvbiB0aGUgc2FtZSBjb2x1bW5z IG9mIHRoZSBwcmltYXJ5IGtleSwgYnV0IEknbQpub3Qgc3VyZSB0aGF0IHRoYXQncyB2ZXJ5IHVz ZWZ1bC4gIElmIGNsdXR0ZXIgaXMgYSBwcm9ibGVtLCB3ZSBtaWdodCBiZQpiZXR0ZXIgb2ZmIGlu dmVudGluZyBhIG5ldyBcZCsrIGNvbW1hbmQgYW5kIG5vdCBzaG93aW5nIHRoZSBjb25zdHJhaW50 cwppbiBcZCsuCgpGb3Igbm93LCB3ZSBvbWl0IHRoZXNlIGNvbnN0cmFpbnRzIG9uIHN5c3RlbSBj YXRhbG9nIGNvbHVtbnMsIGJlY2F1c2UKdGhleSdyZSB1bmxpa2VseSB0byBhY2hpZXZlIGFueXRo aW5nLgoKVGhlIG1haW4gZGlmZmVyZW5jZSB0byB0aGUgcHJldmlvdXMgYXR0ZW1wdCBhdCB0aGlz IChiMGU5NmYzMTE5ODUpIGlzCnRoYXQgd2Ugbm93IHJlcXVpcmUgdGhhdCBzdWNoIGEgY29uc3Ry YWludCBhbHdheXMgZXhpc3RzIHdoZW4gYSBwcmltYXJ5CmtleSBpcyBpbiB0aGUgY29sdW1uOyB3 ZSBkaWRuJ3QgcmVxdWlyZSB0aGlzIHByZXZpb3VzbHkgd2hpY2ggaGFkIGEKbnVtYmVyIG9mIHVu cGFsYXRhYmxlIGNvbnNlcXVlbmNlcy4gIFdpdGggdGhpcyByZXF1aXJlbWVudCwgdGhlIGNvZGUg aXMKZWFzaWVyIHRvIHJlYXNvbiBhYm91dC4gIEZvciBleGFtcGxlOgoKLSBXZSBubyBsb25nZXIg aGF2ZSAidGhyb3dhd2F5IGNvbnN0cmFpbnRzIiBkdXJpbmcgcGdfZHVtcC4gIFdlIG5lZWRlZAog IHRob3NlIGZvciB0aGUgY2FzZSB3aGVyZSBhIHRhYmxlIGhhZCBhIFBLIHdpdGhvdXQgYSBub3Qt bnVsbAogIHVuZGVybmVhdGgsIHRvIHByZXZlbnQgYSBzbG93IHNjYW4gb2YgdGhlIGRhdGEgZHVy aW5nIHJlc3RvcmUgb2YgdGhlCiAgUEsgY3JlYXRpb24sIHdoaWNoIHdhcyBwYXJ0aWN1bGFybHkg cHJvYmxlbWF0aWMgZm9yIHBnX3VwZ3JhZGUuCgotIFdlIG5vIGxvbmdlciBoYXZlIHRvIGNvcGUg d2l0aCBhdHRub3RudWxsIGJlaW5nIHNldCBzcHVyaW91c2x5IGluCiAgY2FzZSBhIHByaW1hcnkg a2V5IGlzIGRyb3BwZWQgaW5kaXJlY3RseSAoZS5nLiwgdmlhIERST1AgQ09MVU1OKS4KClNvbWUg Yml0cyBvZiBjb2RlIGluIHRoaXMgcGF0Y2ggd2VyZSBhdXRob3JlZCBieSBKaWFuIEhlLgoKQXV0 aG9yOiDDgWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGFsdmgubm8taXAub3JnPgpBdXRob3I6IEJl cm5kIEhlbG1sZSA8bWFpbGluZ3NAb29wc3dhcmUuZGU+ClJldmlld2VkLWJ5OiDkvZXlu7ogKGpp YW4gaGUpIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiDnjovliJog KFRlbmRlciBXYW5nKSA8dG5kcndhbmdAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogSnVzdGluIFBy eXpieSA8cHJ5emJ5QHRlbHNhc29mdC5jb20+ClJldmlld2VkLWJ5OiBQZXRlciBFaXNlbnRyYXV0 IDxwZXRlci5laXNlbnRyYXV0QGVudGVycHJpc2VkYi5jb20+ClJldmlld2VkLWJ5OiBEZWFuIFJh c2hlZWQgPGRlYW4uYS5yYXNoZWVkQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS8yMDI0MDgzMTAzNTguc2RodW10eXV5Mmh0QGFsdmhlcnJlLnBnc3FsCgpCcmFuY2gK LS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3Jn L3BnL2NvbW1pdGRpZmYvMTRlODdmZmE1YzU0M2I1ZjMwZWFkNzQxMzA4NGMyNWY3NzM1MDM5ZgoK TW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9zZXBnc3FsL2V4cGVjdGVkL2Fs dGVyLm91dCAgICAgICAgICAgICAgICAgfCAgICAzIC0KY29udHJpYi90ZXN0X2RlY29kaW5nL2V4 cGVjdGVkL2RkbC5vdXQgICAgICAgICAgICAgfCAgIDEyICsKZG9jL3NyYy9zZ21sL2NhdGFsb2dz LnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDEyICstCmRvYy9zcmMvc2dtbC9kZGwu c2dtbCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICA2NSArLQpkb2Mvc3JjL3NnbWwv cmVmL2FsdGVyX2ZvcmVpZ25fdGFibGUuc2dtbCAgICAgICAgICB8ICAgIDYgKy0KZG9jL3NyYy9z Z21sL3JlZi9hbHRlcl90YWJsZS5zZ21sICAgICAgICAgICAgICAgICAgfCAgIDMwICstCmRvYy9z cmMvc2dtbC9yZWYvY3JlYXRlX2ZvcmVpZ25fdGFibGUuc2dtbCAgICAgICAgIHwgICAxMCArLQpk b2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sICAgICAgICAgICAgICAgICB8ICAgMTcg Ky0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMgICAgICAgICAgICAgICAgICAgICAgICAgfCAg MzkxICsrKysrLQpzcmMvYmFja2VuZC9jYXRhbG9nL2luZm9ybWF0aW9uX3NjaGVtYS5zcWwgICAg ICAgICB8ICAgNzEgKy0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9wZ19jb25zdHJhaW50LmMgICAgICAg ICAgICAgICAgfCAgMjUyICsrKysKc3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMgICAg ICAgICAgICAgICAgICAgfCAxMjY0ICsrKysrKysrKysrKystLS0tLS0tCnNyYy9iYWNrZW5kL2Nv bW1hbmRzL3R5cGVjbWRzLmMgICAgICAgICAgICAgICAgICAgIHwgICAgNCArCnNyYy9iYWNrZW5k L25vZGVzL21ha2VmdW5jcy5jICAgICAgICAgICAgICAgICAgICAgIHwgICAyMyArCnNyYy9iYWNr ZW5kL29wdGltaXplci91dGlsL3BsYW5jYXQuYyAgICAgICAgICAgICAgIHwgICAgMiArCnNyYy9i YWNrZW5kL3BhcnNlci9ncmFtLnkgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAyMyArLQpz cmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfdXRpbGNtZC5jICAgICAgICAgICAgICAgICB8ICAzNDIg KysrKy0tCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvcmVsYXRpb24uYyAgICAgICAg IHwgICAgMiArLQpzcmMvYmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMgICAgICAgICAgICAg ICAgICB8ICAgMjIgKwpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9yZWxjYWNoZS5jICAgICAgICAg ICAgICAgICB8ICAgNDQgKy0Kc3JjL2Jpbi9wZ19kdW1wL2NvbW1vbi5jICAgICAgICAgICAgICAg ICAgICAgICAgICAgfCAgIDMwICstCnNyYy9iaW4vcGdfZHVtcC9wZ19kdW1wLmMgICAgICAgICAg ICAgICAgICAgICAgICAgIHwgIDMwNSArKysrLQpzcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5oICAg ICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDggKy0Kc3JjL2Jpbi9wZ19kdW1wL3QvMDAyX3Bn X2R1bXAucGwgICAgICAgICAgICAgICAgICAgfCAgICA2ICstCnNyYy9iaW4vcHNxbC9kZXNjcmli ZS5jICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICA0NCArCnNyYy9iaW4vcHNxbC90LzAx MF90YWJfY29tcGxldGlvbi5wbCAgICAgICAgICAgICAgIHwgICAgOCArLQpzcmMvaW5jbHVkZS9j YXRhbG9nL2NhdHZlcnNpb24uaCAgICAgICAgICAgICAgICAgICB8ICAgIDIgKy0Kc3JjL2luY2x1 ZGUvY2F0YWxvZy9oZWFwLmggICAgICAgICAgICAgICAgICAgICAgICAgfCAgICA4ICstCnNyYy9p bmNsdWRlL2NhdGFsb2cvcGdfY29uc3RyYWludC5oICAgICAgICAgICAgICAgIHwgICAgNyArCnNy Yy9pbmNsdWRlL25vZGVzL21ha2VmdW5jcy5oICAgICAgICAgICAgICAgICAgICAgIHwgICAgMSAr CnNyYy9pbmNsdWRlL25vZGVzL3BhcnNlbm9kZXMuaCAgICAgICAgICAgICAgICAgICAgIHwgICAx MCArLQpzcmMvaW5jbHVkZS91dGlscy9yZWxjYWNoZS5oICAgICAgICAgICAgICAgICAgICAgICB8 ICAgIDIgKy0KLi4uL3Rlc3RfZGRsX2RlcGFyc2UvZXhwZWN0ZWQvYWx0ZXJfdGFibGUub3V0ICAg ICAgfCAgIDE3ICstCi4uLi90ZXN0X2RkbF9kZXBhcnNlL2V4cGVjdGVkL2NyZWF0ZV90YWJsZS5v dXQgICAgIHwgICAgMiAtCi4uLi9tb2R1bGVzL3Rlc3RfZGRsX2RlcGFyc2UvdGVzdF9kZGxfZGVw YXJzZS5jICAgIHwgICAgMyAtCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYWx0ZXJfdGFibGUu b3V0ICAgICAgICAgIHwgICA0OSArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NsdXN0ZXIu b3V0ICAgICAgICAgICAgICB8ICAgIDcgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9jb25z dHJhaW50cy5vdXQgICAgICAgICAgfCAgNTI1ICsrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvY3JlYXRlX3RhYmxlLm91dCAgICAgICAgIHwgICAzNSArLQpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL2NyZWF0ZV90YWJsZV9saWtlLm91dCAgICB8ICAgMzQgKy0Kc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9mb3JlaWduX2RhdGEub3V0ICAgICAgICAgfCAgMTEwICstCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvZm9yZWlnbl9rZXkub3V0ICAgICAgICAgIHwgICAxNiArLQpzcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZF9zdG9yZWQub3V0ICAgICB8ICAgIDIgKwpz cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2lkZW50aXR5Lm91dCAgICAgICAgICAgICB8ICAgIDYg Ky0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbmRleF9pbmNsdWRpbmcub3V0ICAgICAgfCAg ICA0ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5kZXhpbmcub3V0ICAgICAgICAgICAg IHwgICA1NiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2luaGVyaXQub3V0ICAgICAgICAg ICAgICB8ICA2MTIgKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0 aW9uLm91dCAgICAgICAgICB8ICAgMTUgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3JlcGxp Y2FfaWRlbnRpdHkub3V0ICAgICB8ICAgMjQgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3Jv d3NlY3VyaXR5Lm91dCAgICAgICAgICB8ICAgIDIgKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9hbHRl cl90YWJsZS5zcWwgICAgICAgICAgICAgICB8ICAgMjkgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwv Y29uc3RyYWludHMuc3FsICAgICAgICAgICAgICAgfCAgMTg1ICsrKwpzcmMvdGVzdC9yZWdyZXNz L3NxbC9jcmVhdGVfdGFibGVfbGlrZS5zcWwgICAgICAgICB8ICAgIDUgKy0Kc3JjL3Rlc3QvcmVn cmVzcy9zcWwvaW5kZXhfaW5jbHVkaW5nLnNxbCAgICAgICAgICAgfCAgICA0ICstCnNyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL2luZGV4aW5nLnNxbCAgICAgICAgICAgICAgICAgIHwgICAgMyArLQpzcmMv dGVzdC9yZWdyZXNzL3NxbC9pbmhlcml0LnNxbCAgICAgICAgICAgICAgICAgICB8ICAyNzggKysr KysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvcmVwbGljYV9pZGVudGl0eS5zcWwgICAgICAgICAgfCAg IDE1ICsKNTcgZmlsZXMgY2hhbmdlZCwgNDI0NiBpbnNlcnRpb25zKCspLCA4MTggZGVsZXRpb25z KC0pCgo= --===============1271984662087092873==--