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 1tdEkU-005oNe-1m for pgsql-committers@arkaria.postgresql.org; Wed, 29 Jan 2025 20:33:22 +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 1tdEkT-008mut-6o for pgsql-committers@arkaria.postgresql.org; Wed, 29 Jan 2025 20:33:21 +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 1tdEjW-008lNs-6k for pgsql-committers@lists.postgresql.org; Wed, 29 Jan 2025 20:32:22 +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.96) (envelope-from ) id 1tdEjQ-002EPo-2J for pgsql-committers@lists.postgresql.org; Wed, 29 Jan 2025 20:32:21 +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 1tdEjP-00CkKp-2U for pgsql-committers@lists.postgresql.org; Wed, 29 Jan 2025 20:32:15 +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 1tdEjO-004HGR-00 for pgsql-committers@lists.postgresql.org; Wed, 29 Jan 2025 20:32:14 +0000 Content-Type: multipart/mixed; boundary="===============8300753644217357014==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Handle default NULL insertion a little better. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 29 Jan 2025 20:32:14 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8300753644217357014== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGFuZGxlIGRlZmF1bHQgTlVMTCBpbnNlcnRpb24gYSBsaXR0bGUgYmV0dGVyLgoKSWYgYSBjb2x1 bW4gaXMgb21pdHRlZCBpbiBhbiBJTlNFUlQsIGFuZCB0aGVyZSdzIG5vIGNvbHVtbiBkZWZhdWx0 LAp0aGUgY29kZSBpbiBwcmVwdGxpc3QuYyBnZW5lcmF0ZXMgYSBOVUxMIENvbnN0IHRvIGJlIGlu c2VydGVkLgpGdXJ0aGVybW9yZSwgaWYgdGhlIGNvbHVtbiBpcyBvZiBhIGRvbWFpbiB0eXBlLCB3 ZSB3cmFwIHRoZSBDb25zdAppbiBDb2VyY2VUb0RvbWFpbiwgc28gYXMgdG8gdGhyb3cgYSBydW4t dGltZSBlcnJvciBpZiB0aGUgZG9tYWluCmhhcyBhIE5PVCBOVUxMIGNvbnN0cmFpbnQuICBUaGF0 J3MgZmluZSBhcyBmYXIgYXMgaXQgZ29lcywgYnV0CnRoZXJlIGFyZSB0d28gcHJvYmxlbXM6Cgox LiBXZSdyZSBiZWluZyBzbG9wcHkgYWJvdXQgdGhlIHR5cGUvdHlwbW9kIHRoYXQgdGhlIENvbnN0 IGlzCmxhYmVsZWQgd2l0aC4gIEl0IHJlYWxseSBzaG91bGQgaGF2ZSB0aGUgZG9tYWluJ3MgYmFz ZSB0eXBlL3R5cG1vZCwKc2luY2UgaXQncyB0aGUgaW5wdXQgdG8gQ29lcmNlVG9Eb21haW4gbm90 IHRoZSBvdXRwdXQuICBUaGlzIGNhbgpyZXN1bHQgaW4gY29lcmNlX3RvX2RvbWFpbiBpbnNlcnRp bmcgYSB1c2VsZXNzIGxlbmd0aC1jb2VyY2lvbgpmdW5jdGlvbiAodXNlbGVzcyBiZWNhdXNlIGl0 J3MgYmVpbmcgYXBwbGllZCB0byBhIG51bGwpLiAgVGhlCmNvZXJjaW9uIHdvdWxkIHR5cGljYWxs eSBnZXQgY29uc3QtZm9sZGVkIGF3YXkgbGF0ZXIsIGJ1dCBpdCdkCmJlIGJldHRlciBub3QgdG8g Y3JlYXRlIGl0IGluIHRoZSBmaXJzdCBwbGFjZS4KCjIuIFdlJ3JlIG5vdCBhcHBseWluZyBleHBy ZXNzaW9uIHByZXByb2Nlc3NpbmcgKHNwZWNpZmljYWxseSwKZXZhbF9jb25zdF9leHByZXNzaW9u cykgdG8gdGhlIHJlc3VsdGluZyBleHByZXNzaW9uIHRyZWUuClRoZSBwbGFubmVyJ3MgcHJpbWFy eSBleHByZXNzaW9uLXByZXByb2Nlc3NpbmcgcGFzcyBhbHJlYWR5IGhhcHBlbmVkLApzbyB0aGF0 IG1lYW5zIHRoZSBsZW5ndGggY29lcmNpb24gc3RlcCBhbmQgQ29lcmNlVG9Eb21haW4gbm9kZSBt aXNzCnByZXByb2Nlc3NpbmcgYWx0b2dldGhlci4KClRoaXMgaXMgYXQgdGhlIGxlYXN0IGluZWZm aWNpZW50LCBzaW5jZSBpdCBtZWFucyB0aGUgbGVuZ3RoIGNvZXJjaW9uCmFuZCBDb2VyY2VUb0Rv bWFpbiB3aWxsIGFjdHVhbGx5IGJlIGV4ZWN1dGVkIGZvciBlYWNoIGluc2VydGVkIHJvdywKdGhv dWdoIHRoZXkgY291bGQgYmUgY29uc3QtZm9sZGVkIGF3YXkgaW4gbW9zdCBjYXNlcy4gIFdvcnNl LCBpdApzZWVtcyBwb3NzaWJsZSB0aGF0IG1pc3NpbmcgcHJlcHJvY2Vzc2luZyBmb3IgdGhlIGxl bmd0aCBjb2VyY2lvbgpjb3VsZCByZXN1bHQgaW4gYW4gaW52YWxpZCBwbGFuIChmb3IgZXhhbXBs ZSwgZHVlIHRvIGZhaWxpbmcgdG8KcGVyZm9ybSBkZWZhdWx0LWZ1bmN0aW9uLWFyZ3VtZW50IGlu c2VydGlvbikuICBJJ20gbm90IGF3YXJlIG9mCmFueSBsaXZlIGJ1ZyBvZiB0aGF0IHNvcnQgd2l0 aCBjb3JlIGRhdGF0eXBlcywgYW5kIGl0IG1pZ2h0IGJlCnVucmVhY2hhYmxlIGZvciBleHRlbnNp b24gdHlwZXMgYXMgd2VsbCBiZWNhdXNlIG9mIHJlc3RyaWN0aW9ucyBvZgpDUkVBVEUgQ0FTVCwg YnV0IEknbSBub3QgZW50aXJlbHkgY29udmluY2VkIHRoYXQgaXQncyB1bnJlYWNoYWJsZS4KSGVu Y2UsIGl0IHNlZW1zIHdvcnRoIGJhY2stcGF0Y2hpbmcgdGhlIGZpeCAoYWx0aG91Z2ggSSBvbmx5 IHdlbnQKYmFjayB0byB2MTQsIGFzIHRoZSBwYXRjaCBkb2Vzbid0IGFwcGx5IGNsZWFubHkgYXQg YWxsIGluIHYxMykuCgpUaGVyZSBhcmUgc2V2ZXJhbCBwbGFjZXMgaW4gdGhlIHJld3JpdGVyIHRo YXQgYXJlIGJ1aWxkaW5nIG51bGwKZG9tYWluIGNvbnN0YW50cyB0aGUgc2FtZSB3YXkgYXMgcHJl cHRsaXN0LmMuICBXaGlsZSB0aG9zZSBhcmUKYmVmb3JlIHRoZSBwbGFubmVyIGFuZCBoZW5jZSBk b24ndCBoYXZlIGFueSByZWFjaGFibGUgYnVnLCB0aGV5J3JlCnN0aWxsIGFwcGx5aW5nIGEgbGVu Z3RoIGNvZXJjaW9uIHRoYXQgd2lsbCBiZSBjb25zdC1mb2xkZWQgYXdheQpsYXRlciwgdXNlbGVz c2x5IHdhc3RpbmcgY3ljbGVzLiAgSGVuY2UsIG1ha2UgYSB1dGlsaXR5IHJvdXRpbmUKdGhhdCBh bGwgb2YgdGhlc2UgcGxhY2VzIGNhbiBjYWxsIHRvIGRvIGl0IHJpZ2h0LgoKTWFraW5nIHRoaXMg Y29kZSBtb3JlIGNhcmVmdWwgYWJvdXQgdGhlIHR5cG1vZCBhc3NpZ25lZCB0byB0aGUKZ2VuZXJh dGVkIE5VTEwgY29uc3RhbnQgaGFzIHZpc2libGUgYnV0IGNvc21ldGljIGVmZmVjdHMgb24gc29t ZQpvZiB0aGUgcGxhbnMgc2hvd24gaW4gY29udHJpYi9wb3N0Z3Jlc19mZHcncyByZWdyZXNzaW9u IHRlc3RzLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xODY1NTc5LjE3MzgxMTM2 NTZAc3NzLnBnaC5wYS51cwpCYWNrcGF0Y2gtdGhyb3VnaDogMTQKCkJyYW5jaAotLS0tLS0KUkVM XzE0X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3Bn L2NvbW1pdGRpZmYvYzA1MjY4ZTZlYzkzMTcyNDI4MmI1NzgwZjIyOGU1YTFhYWQ5NDI2OAoKTW9k aWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvZXhwZWN0ZWQv cG9zdGdyZXNfZmR3Lm91dCB8IDI0ICsrKysrKystLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6 ZXIvcHJlcC9wcmVwdGxpc3QuYyAgICAgICAgIHwgMzEgKysrKysrKystLS0tLS0tLS0tLQpzcmMv YmFja2VuZC9wYXJzZXIvcGFyc2VfY29lcmNlLmMgICAgICAgICAgICAgIHwgMzcgKysrKysrKysr KysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvcmV3cml0ZS9yZXdyaXRlSGFuZGxlci5jICAgICAg ICAgICB8IDQyICsrKysrKy0tLS0tLS0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3Jld3JpdGUv cmV3cml0ZU1hbmlwLmMgICAgICAgICAgICAgfCAzMCArKysrKysrKystLS0tLS0tLS0Kc3JjL2lu Y2x1ZGUvcGFyc2VyL3BhcnNlX2NvZXJjZS5oICAgICAgICAgICAgICB8ICAzICsrCjYgZmlsZXMg Y2hhbmdlZCwgOTAgaW5zZXJ0aW9ucygrKSwgNzcgZGVsZXRpb25zKC0pCgo= --===============8300753644217357014==--