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 1s0RCa-0049LV-UR for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Apr 2024 19:25:44 +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 1s0RCX-00Ewgj-Pp for pgsql-hackers@arkaria.postgresql.org; Fri, 26 Apr 2024 19:25:42 +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 1s0RCX-00EwgO-Da for pgsql-hackers@lists.postgresql.org; Fri, 26 Apr 2024 19:25:42 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s0RCV-000Boa-OO for pgsql-hackers@lists.postgresql.org; Fri, 26 Apr 2024 19:25:41 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-a58d0aea14cso133662866b.2 for ; Fri, 26 Apr 2024 12:25:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1714159537; x=1714764337; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=IABGqBEpQtNsFjYtwHsp69bLEEVm6bhbzyzqtTUcjtM=; b=Ck/xzOkO/njgr6P+W4CmKxUEaxhqtCLBrit0gQltHpcR7/tZMkag2wrPB/xzgn5+Fr TZpZhWV6IU2FczZsJ/lxnvnzvZab9RA3Ov6r1vNJyPAeS/fTz1TOQPWgMD5hJ8G+yKJT Y5f/jXV4zidCpMKbt61+P2acmdWyEtcySU5O9aP3WmXWlLzFy0Jjv4tLBURVMSOg6IC/ ttKqcJ+k5F7cpethI3hfyykYzVaY1Xj49eTMz36Sz3kfbMHQ4YGRY4q+ZaaYCHfdCbHk f8azaZPtR4XeSq9jeJFQm5OINZyk88DuQ7zEGVllLxjumyaAH2s6CvmTeto1quXtVow5 dLzw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1714159537; x=1714764337; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=IABGqBEpQtNsFjYtwHsp69bLEEVm6bhbzyzqtTUcjtM=; b=M86ihK++2+nSJggp99HVS6Cleg+HqVIrTXz7mM/ih6eGBK/kyqNtXIiBhIwvhd0zaz kdabKBQ26l+Nk/kFKTj5TAllT42su4elWu0og32tox3Qs+57Su8YeJhP+0t7TdLYJMHo 1QS7U99iMVFvyhrVp8j/gDR7OImyJq5Y3uq751t4y7ib5f1h835dkAr3Dsh4HpdqAsYU Lknm2mtwugURGn3n4FZoC4udawzGLaJ7MIQIz4bCqN7+Za2zn6dhBvemQGJmGB8dsn+p l7DRRkGMGTWd/2xfz2gTcaqxoH8i+UoBhcyj+gjbQzn+J0qerRoVnoaPuiUmsDAGdqrq jgyw== X-Forwarded-Encrypted: i=1; AJvYcCWXwwluuXKmvHKL4ZlFKhTGVQlaMg/myout1VkoKzh4EHWQNry3UpiQuUbxaMrn4L8VrvPv0QU9EcPNbuiiukHdBpVYThjqo7QTxrX+nNctlYfR X-Gm-Message-State: AOJu0Yx1zlHvefXFH7oyqd8St5wBlGrofqiT8MD/rYcRh3w2EBJIEIJ4 u3Gad8ot882zZj/31u41qHtNcLvtjH69k62Z/60vPDgbTfNFwjEboAncU9PEDeyMFJS9Sc81n8e DXBNo7sfEreqOFTgwqh7A2nJDMrE= X-Google-Smtp-Source: AGHT+IFerBYaFuo2Vcd0Sldhpo6D5eCWn592ldAFzfstlR4DdZCVx4MbtqoGkgQ47D8mv+9N3OlUtnAqZFMN+QTT4g4= X-Received: by 2002:a17:906:786:b0:a52:6cb2:9347 with SMTP id l6-20020a170906078600b00a526cb29347mr2139342ejc.8.1714159537339; Fri, 26 Apr 2024 12:25:37 -0700 (PDT) MIME-Version: 1.0 References: <0d977c63-f4a6-43ba-aad0-35c06c55df11@eisentraut.org> <85dd3ad0-fa79-46e8-a08b-c426c76825f3@eisentraut.org> <49c07eac-18ec-4aff-929c-e81b87df1092@eisentraut.org> <1edb3b79-a4bc-43b1-80aa-2e090472fe32@eisentraut.org> <47550967-260b-4180-9791-b224859fe63e@illuminatedcomputing.com> In-Reply-To: <47550967-260b-4180-9791-b224859fe63e@illuminatedcomputing.com> From: Robert Haas Date: Fri, 26 Apr 2024 15:25:26 -0400 Message-ID: Subject: Re: SQL:2011 application time To: Paul Jungwirth Cc: Peter Eisentraut , jian he , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 3, 2024 at 1:30=E2=80=AFAM Paul Jungwirth wrote: > I found some problems with temporal primary keys and the idea of uniquene= ss, especially around the > indisunique column. Here are some small fixes and a proposal for a larger= fix, which I think we need > but I'd like some feedback on. I think this thread should be added to the open items list. You're raising questions about whether the feature that was committed to this release is fully correct. If it isn't, we shouldn't release it without fixing it. https://wiki.postgresql.org/wiki/PostgreSQL_17_Open_Items --=20 Robert Haas EDB: http://www.enterprisedb.com