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 1v9EgC-00DHjg-BD for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Oct 2025 03:29:27 +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 1v9EgA-009eju-3K for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Oct 2025 03:29:25 +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 1v9Eg9-009ejl-Ps for pgsql-hackers@lists.postgresql.org; Thu, 16 Oct 2025 03:29:24 +0000 Received: from mail-ua1-x92c.google.com ([2607:f8b0:4864:20::92c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v9Eg6-002Rg7-0y for pgsql-hackers@lists.postgresql.org; Thu, 16 Oct 2025 03:29:24 +0000 Received: by mail-ua1-x92c.google.com with SMTP id a1e0cc1a2514c-8e364003538so159238241.3 for ; Wed, 15 Oct 2025 20:29:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760585359; x=1761190159; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=68vKCO9oXCqxPYRwDqNU4bMOPb5jQEz8O3hBHHBL6tQ=; b=llTqSwXV9vVjIZS71DdXTJbMPXGiEzwkrz+JirjizfgXiPT6KElga4xRinmitr+6pS B5D/N0xq171Z4dPVmjFkujhLMT7eL2ywgqE66ZSKY/8uYRUPLkVMumQRyRn8kYJS/Pab LdQIUK+jFZMlz4Ze7nm4iZ7BEMuHAgwan7hyZRS6uOkEIlhbxd/SIcCTV94YTu1wbryO jr+wru6CsMCH5gXqLVYB+A6Om7ffFd94zLu1Jas5i5GszrowxyDz7ZgBXXExyur9WcL7 lHLAtxwPmMUCSgdgIRFBfYTrI+ulO/BaogQ6sWBK+Vwu2dmXOV7pS116t0vSHMws829B Cnxw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760585359; x=1761190159; h=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=68vKCO9oXCqxPYRwDqNU4bMOPb5jQEz8O3hBHHBL6tQ=; b=cMtW4SON1xwkHQ9bjQLE7Ww9wsR63/WoQV0RSTGIbnuXSbhQSgrXupJP9SB1ry4dnu hO23z3LUqKBDyPtAFR0RrNCkz/2tnj6b155eb4rrHfTGmgmq/1tageAO7MtorCKCk4kS meyUONbvJyuBaG9ix6GATZolhTx5+8JAuqc5D+++gg/3rz6JQiGbC8rEVIk2qSqx4hoV 3p0RphlhSUsO6GQwkLBw1TOo8e4mRRv+aE1pWai4qn6QbSjZ0HLzRU1pcFsb7Pq/N7/Y CvxSrACNKBINqq57AQgY/NycwvAfUdJxI51KQI9ejmeUhSEsyiyhi/pFhKaX52oS80Qz oYjA== X-Forwarded-Encrypted: i=1; AJvYcCXrklSufAtQTn+XTbJ9cPRqexiemB4bmsWCH3dKWm8AsP8qqfTbWwEZldJKCLl4JOkkntG4LDlp03ZAtFeK@lists.postgresql.org X-Gm-Message-State: AOJu0YyDxHb6hk6vOQxwAZzZTzcyPfdAxxBIgy60wLeeZJrR3hEzBzwx J/2sRok8x42+oM8hrPjiCpN5cykd9BsVSaS6Yyq9Nt53WmtEKPjz4k5sKZaLyFtuAQOEnHh+qI2 CbM4uBxgmMLxXNLTm60ufEqXthewCph8= X-Gm-Gg: ASbGncv4hx3bJyg8JfnxssCtkkVs5RiHgUL61J0aqNdlw6rTlo6Azqvx2bOeTaqA1Xn lTJARLgrGqMSvSzFM4AFfRGxXlWAmWUCiyhPNxcEqrn2Xi+QozAxDC2VwtAacmN/ToaqBtIGlqr stSsQx+G/gmQqyGIQ9SYivityMmhWHxnpIs/M7HB7kGAlTeeVgvO+dTxpW21qIe5SndM8l4o+ya f/LsDKdld6PGFR+RZchDcToxfoTTrt1fO/1NcCdSyDO+l/yw9o8/6pfv70ns5msf7qUSuzVYE5z DC/+tlTnETCni8JPrIE/+gNyAZtEusu1xB+sWZFfB+qkJE4APt8AzLVnwuEgSrYl9F2jXcyUaQK 91YrH9akQel+IPxkUgvBSj9sUZ6fLGSdnVyxcQdg2+n/utz770XPu2GU5JU4TPEjUNa7EPdLHP+ X+jw== X-Google-Smtp-Source: AGHT+IFyWgsl16+qftBmxz1moG/DO5YDBxPCudobY5Y+nNZN4UYJ+NvA95quE5gKKCGMN+oozCjLBh0/bHDWrbicD50= X-Received: by 2002:a05:6102:1613:b0:5d5:f6ae:3907 with SMTP id ada2fe7eead31-5d5f6ae3dcamr10287029137.37.1760585359376; Wed, 15 Oct 2025 20:29:19 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: jian he Date: Thu, 16 Oct 2025 11:28:43 +0800 X-Gm-Features: AS18NWBI7lMYmW9_y1g1i3EziwT7FBoWiohoB0yYMJawEPV9EKhBuvcf4K0ZHWY Message-ID: Subject: Re: doc: create table improvements To: Laurenz Albe Cc: "David G. Johnston" , Peter Eisentraut , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk hi. -where column_constraint is: +where persistence_mode is: + +[ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | +UNLOGGED we can just do it with one line: [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED most of the time, the patch using: persistence_mode oversize_storage for column_constraint we are using column_constraint do we need change it to persistence_mode oversize_storage ? I don't know the purpose of this extra ``"class="parameter"``.