Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsOrK-0002vz-5v for pgsql-hackers@arkaria.postgresql.org; Sat, 21 May 2022 13:09:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nsOrI-000749-Tu for pgsql-hackers@arkaria.postgresql.org; Sat, 21 May 2022 13:09:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsOrI-000740-Df for pgsql-hackers@lists.postgresql.org; Sat, 21 May 2022 13:09:28 +0000 Received: from mail-qt1-x82e.google.com ([2607:f8b0:4864:20::82e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nsOrF-0008PB-VG for pgsql-hackers@lists.postgresql.org; Sat, 21 May 2022 13:09:27 +0000 Received: by mail-qt1-x82e.google.com with SMTP id u3so9637754qta.8 for ; Sat, 21 May 2022 06:09:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :user-agent; bh=hT37yizD2i3bBEWgSSltsx/JKKOOMXGH1FmuMqYsHlQ=; b=V3BEgaELBv6ol8AdtN7aN7uWKqY7EuEqaFlbCR9MWlBsI3U/zh9ubwhsufErkATSbK pw/DzkCmudJ8YZjyOr43Xcqm/iCr4gQD8+B2Xs4pOY5K7NAPd9Lr94C0rCHh+hYAy+jg vXYlOmuP9aMXVvphHh+9HkbGhyWielpcuJ7DBfd9YOEL1cJ3hA6VA0NBhOWtO3N1VIco pO6dlprBtb+4lT0Pganuk+kO4IyCwjTzHeh43pZQrxoUivo/ZMcDqm0vSORNd2XI8Jkl OxmLoXVz4gJd/xwHwFkiA5Uv7Qn3/hIuJqtjFEYfUMH7SA7YHfZup778yago3179AYeN mxUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:user-agent; bh=hT37yizD2i3bBEWgSSltsx/JKKOOMXGH1FmuMqYsHlQ=; b=cUes0qQxI+bvaCRJNZnSUf4hJltEZ8EKNNggFIh6ST1482wbhdyocpnOPfZsI9TPrQ OCSiMuWAAZTSlESCHdBgxypctWT3Rs18BZcG25iVmdKJUGlQ4hPEzg6KU6ABTA4vhLSL QD1U12IDTFBWP4id1qFjjIlVQKafaAv0c7e4FIhQ+IMSWa2UjdO9Yy0vYnqbyROvWWfz UfDEd57rUvyJ00jGGEb2ITKY99k3PrBsa+l1aFVMh77bmlSv1Xx0Qpg/ioEv9wiBCMUN I4e1Ou4zyMEHruoi75FONdVGmkMw424+P2sYNUUALKoB/tD4WqyrnHHUEek/pfBeYJ0W wKBg== X-Gm-Message-State: AOAM531WV7JSrv/8tvGKw5hlmmwy24sr4Q9/NIfplmOpzdKih5hQWWh0 1+5+RwbGsHvPpjJaMYUOC5bdfw== X-Google-Smtp-Source: ABdhPJyGOwmwPfHFKLE1ouLZ7q8CTqQaftP5lNvTv0M3sx/xYVHykvo5IdaQXJqic+S2UpIlKhgaKA== X-Received: by 2002:ac8:5c95:0:b0:2f3:da4c:6ac0 with SMTP id r21-20020ac85c95000000b002f3da4c6ac0mr10506487qta.531.1653138564106; Sat, 21 May 2022 06:09:24 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id k123-20020a37ba81000000b0069fc13ce1ddsm1346764qkf.14.2022.05.21.06.09.23 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 21 May 2022 06:09:23 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id C240B8008F8; Sat, 21 May 2022 08:09:22 -0500 (CDT) Date: Sat, 21 May 2022 08:09:22 -0500 From: Justin Pryzby To: pgsql-hackers@lists.postgresql.org Cc: Robert Haas , Jeevan Ladhe Subject: doc: CREATE FOREIGN TABLE .. PARTITION OF .. DEFAULT Message-ID: <20220521130922.GX19626@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk It looks like the docs weren't updated in 6f6b99d13 for v11. The docs also seem to omit "FOR VALUES" literal. And don't define partition_bound_spec (which I didn't fix here). diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index b374d8645db..1f1c4a52a2a 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -35,7 +35,8 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name { column_name [ WITH OPTIONS ] [ column_constraint [ ... ] ] | table_constraint } [, ... ] -) ] partition_bound_spec +) ] + { FOR VALUES partition_bound_spec | DEFAULT } SERVER server_name [ OPTIONS ( option 'value' [, ... ] ) ]