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 1rSgBZ-00FDfv-F0 for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 16:33:10 +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 1rSgBV-006LZv-QH for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 16:33:05 +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 1rSgBV-006LZn-Gw for pgsql-hackers@lists.postgresql.org; Wed, 24 Jan 2024 16:33:05 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSgBS-0039iX-L3 for pgsql-hackers@lists.postgresql.org; Wed, 24 Jan 2024 16:33:04 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id A60053200AF1; Wed, 24 Jan 2024 11:33:00 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 24 Jan 2024 11:33:00 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm2; t=1706113980; x=1706200380; bh=y9J6viP3H6zJQZybjG5xG+F8IFBDsA+u LVjSaEtJFs8=; b=mWgYL9IB+CVeZLjajHWPX1rVacoSWXG5Pg7gzQfIpM1qlFw6 KK+Jxs50jgj+bq5d2poODcEvYpGKB+7Yj1VH9LkaYtB11a3r3FfmHrZn0X99YMQB J4js7Gaqhezmd6fmPCmoJ2JYKSiJJz3VQQisz1JUor5W+X0viMCFnZEjmq1BC7vf jGMpZjTQ/cEFZkrTwDTdYictqrGNe4wbBtZmekpuqPQ32wjZYo1HjEURVV5MCyXr 3vSCyu1wdTvIl1a4pYo0qwwu8fRkGQXkxMynZOSvxdNNFMq+xy1AQmUFmnVTwQ8G wZ+HL6Oj/POiXXlrx2r4qwzPh8BmxXM7dsakng== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1706113980; x= 1706200380; bh=y9J6viP3H6zJQZybjG5xG+F8IFBDsA+uLVjSaEtJFs8=; b=Y RyXmESHV44jZEX07lppjpYoAAC+83vqnJDOik2OgJcSsVswAS1KPIBKJn5y7sbma U1SCUxsfO4hBk7zY4BnsGbzDXEGRZ9mmu2Y7jvFd8MSOl0iy411kz8fLodjB7MNU V0FKGm+qjKYeEptn36vzQ+/EFdogS2vyDm3qa/cZbHXNqFRMJfSNy4J0AfepDFRC 3TzNTbaXUlcHO8Qnn8wK1pc89HVQGR03BWQD3t7egxPBRCma0eInSTLLIgekTaFs XK6u/VoCce6UapuFgr5//dMw5ik3hYXl5C9CFFf/x8CvtnsIsOEXDFSXjXkyiEV3 vghkESDI2NnSARW9ajt6g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvdeluddgkeejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgh eqnecuggftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileehteeljeeghfeuledthfeu tedvffdukeefjefhgeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhg X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 24 Jan 2024 11:32:59 -0500 (EST) Message-ID: <88518c81-dcdc-4c5b-9200-146b74a520ab@eisentraut.org> Date: Wed, 24 Jan 2024 17:32:58 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: SQL:2011 application time Content-Language: en-US To: Paul Jungwirth , jian he Cc: PostgreSQL Hackers References: <2d9740ad-3bb7-473c-8441-344351caa8ee@illuminatedcomputing.com> <596fefdd-6202-4228-b7c6-f240b1cbe06e@eisentraut.org> <35400587-6865-4a2c-9ea4-4761669478ea@eisentraut.org> <71b45adb-b496-4e58-b134-0a091014e63f@illuminatedcomputing.com> <7be8724a-5c25-46d7-8325-1bd8be6fa523@eisentraut.org> <0af6a323-f026-4cd9-adf1-941038cd00de@illuminatedcomputing.com> From: Peter Eisentraut In-Reply-To: <0af6a323-f026-4cd9-adf1-941038cd00de@illuminatedcomputing.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 18.01.24 04:59, Paul Jungwirth wrote: > Here are new patches consolidating feedback from several emails. I have committed 0001 and 0002 (the primary key support). The only significant tweak I did was the error messages in GetOperatorFromWellKnownStrategy(), to make the messages translatable better and share wording with other messages. These messages are difficult to reach, so we'll probably have to wait for someone to actually encounter them to see if they are useful. I would like to work on 0003 and 0004 (the foreign key support) during February/March. The patches beyond that are probably too optimistic for PG17. I recommend you focus getting 0003/0004 in good shape soon.