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.96) (envelope-from ) id 1w1wgq-000k0e-0b for pgsql-general@arkaria.postgresql.org; Mon, 16 Mar 2026 01:24:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w1wgp-006kQ0-0s for pgsql-general@arkaria.postgresql.org; Mon, 16 Mar 2026 01:24:16 +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.96) (envelope-from ) id 1w1wgo-006kPr-33 for pgsql-general@lists.postgresql.org; Mon, 16 Mar 2026 01:24:15 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w1wgn-00000000LVJ-0BOk for pgsql-general@lists.postgresql.org; Mon, 16 Mar 2026 01:24:15 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-79800183233so53299877b3.1 for ; Sun, 15 Mar 2026 18:24:13 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773624252; cv=none; d=google.com; s=arc-20240605; b=iuqkvggvml65iWrxYlzqXcirvz9hEWAKimSAA/yWYEyXpDWeihUYyB0Ttfo4fmxe66 u1HZKJhSqgkUvGbnP5s2jaiCV6xL/mCIZutCAeIGlXsVWt9F+EnotNUv2cC3eMncni4y yzdBKwlqj/UcR3UIENH4fszfU4pfUvksd6xk6soOTlksw572TEDg/PSqtpClB5L5XRbE UlXtTlQ4jk9nJTIpiwQsoV61dQ8WN228VARLqwDubJ/PFepY/n032JiAbVScLGFYtjO6 IdLT5S+Eyufq2um1EnYNHMrehneFaKiJeeo4H4uvdwhXwQeGMlj0Ex0hPhxg6iCaeLxq kuvw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=nLs0yPQy3yOZIkglWKvUgp8A39UzCgegVp77W6wPbH0=; fh=WGDn5OiO8A8u5CKi8/0FmLMveU94E7bqeQGsKMalnEw=; b=YdF2o04gnaMwKzx1oOn2fhJVrIxRkGiAnk1jXkPYQJz+3l4w1S6kVwybnB8xt9z+pM utYDQ+MsQkJXtzmF73Ul+MHEczmUk547/pgDLeyBOISnaO19Lc2xxheJ8aIsRjY0YyQQ hKdgS71xYFHN4cydM4Twlb8X4SlYHFBTK72lVwsSIQhEFiqQCaYBQO8HIDwVV6v9XXfr tsxTgn2suJgyxUcOKzzM+HEBx042rnOWRPWsUPrcmlsjI/RvHf39IwY9WpwPu1NOIfKM IG63AMxIYVVTI9xeSjrbgxuMLyJ22gmCfUKWGLnH3CHxjHHbhigJr/OcczE11mLf6ljR Tj6Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773624252; x=1774229052; 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=nLs0yPQy3yOZIkglWKvUgp8A39UzCgegVp77W6wPbH0=; b=eUOrrS8nGUpLA3tUts2lZkfTsH+35qxvuPvFM53YtC99H/2Gr4DwCSYkLfLfgNii+r 2Fp6jhTuroJs83G6nJWKgt4m83sRm1gFzd21xQm7NwFDXkGKcfrO/QX3lEfu32h3sqCQ 4ZU0HgEJH8qmbYikTexi4PfUoGSgK8Fe46p239rEgDMNh41o86Dp9eC2qQhohQf/fBVY 89zkvjnPZ91ZbLvj7MrBwIqwlEIgZJgURur+kS+qRg/6JfdjUTxytPDpsRDl9YeNv2fG 1Um1GfIbIlvZpDEQGMsKiyL0E0uP4yi+AvuQeKMzh3aoFCGh0pLQX0TLrfI+vHf5EgeX DKNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773624252; x=1774229052; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=nLs0yPQy3yOZIkglWKvUgp8A39UzCgegVp77W6wPbH0=; b=Fx3BL+7e6voAJ1O/9qpS/U5RBG5+RttW67DD3CQJ/sOT0kuKKARnqoU2x86izJUYQU eU6MJGSfiAikBO9qgPEN/L/SWrwSL+le9Qx5hPn5tp4sau7gXUDzQhBD1riuvF010rQE 8gqcqzqjISx7H63DXJ8q7hq4y3rZygbHsbrCs4UtsyYkmvVMq44MTLc0f5TBZo+qKy88 dkmo0p7vnwB/fJKSE0gj3845mut+Wk/Q5nTRdsPAK57fylUqftJI5N9Lok8qNtSyR8Rr Mvsw/bKg8dVeHl0k/NZW1ooDe2kkCe8yzX3n0bgnYDtbHBn0TF3LA6xB2fUZ1c+VJ2Es fC3A== X-Forwarded-Encrypted: i=1; AJvYcCVeHYu6ICmFUG7WWLenbpJR+aT0IgaYBmNl3DXlLdupmoLGBeeTeqwJCSGOoxE8Q544XfhuQVi3G8Yct2pe@lists.postgresql.org X-Gm-Message-State: AOJu0YygN3gR82AdbU5say4wWDWO521af7axMo3lUQGRvfh+mLAs8E8T 1vip5DdamReEHibdsDGLS/fOyjbr7MtWvgxmor8jW1FBhD3kP4GbSuh4/jE9v8uzHWI0dmQMcxW QqznknGSO+Pv+4pUeJFwyapnsWRDUzV+PyD+0 X-Gm-Gg: ATEYQzzIIwyueufo5xtIc5toGAdhnwDUthyrnBhDbCD7lU0G/kGBaVkVLYRke67ahNr IudwueSv9fd37pvAitOyzWp1tqdexLOGuIqWwIn5mKkyNAnUCRnDgCdF6ij1T9PS8Dk/vZKgoBj xvGm9vusuojBrvfq79fk/NSoD2CXc+pq5hDga1RGzpjMt8A0xMkA8qcQiesTE5Lcl6jN8rMHOTV 56xUi2jjwcSBUP+JFLWCv+zJYRGHvZEWAUVrXgyUS8Sk3Y5LxNRL66fvakGPsxz3XAKuKtsH2mM q6pG73dh7QscwX4kcfh1EPQDa73lHkNJ3M66pW41dGzNBj4ccvyKMw== X-Received: by 2002:a05:690c:6e83:b0:79a:4f03:b29f with SMTP id 00721157ae682-79a4f03b94amr16008677b3.4.1773624251866; Sun, 15 Mar 2026 18:24:11 -0700 (PDT) MIME-Version: 1.0 References: <3547f40b-08b9-4d0c-bba8-f1c26d0bf09d@aklaver.com> <2c31c118-7f8a-4359-9c4f-4cabd9df4262@aklaver.com> In-Reply-To: <2c31c118-7f8a-4359-9c4f-4cabd9df4262@aklaver.com> From: Igor Korot Date: Sun, 15 Mar 2026 20:23:57 -0500 X-Gm-Features: AaiRm50eJdkOLizZL1N1t7fQzEObI4pqWJSxCxCJP4bABEBXMTyp2Y7dYma65Bo Message-ID: Subject: Re: Does included columns part of the PK To: Adrian Klaver Cc: "David G. Johnston" , "pgsql-generallists.postgresql.org" 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 Hi, Adrian, Here is the log file from running in ODBC mode: https://bpa.st/Z2DWG Thank you. On Sun, Mar 15, 2026 at 10:34=E2=80=AFAM Adrian Klaver wrote: > > On 3/14/26 11:24 PM, Igor Korot wrote: > > Hi, Adrian, > > > > > Lets start with the beginning: > > > > draft=3D# CREATE TABLE leagues_new(id serial, name varchar(100), > > drafttype smallint, scoringtype smallint, roundvalues smallint, > > leaguetype char(5), salary integer, benchplayers smallint, primary > > key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor =3D 50, > > deduplicate_items =3D OFF )); > > CREATE TABLE > > draft=3D# > > I think the above is for this thread: > > https://www.postgresql.org/message-id/CA%2BFnnTyGEM-1mwxKPbwFTOodf%2BYUX%= 3DTxTmBPY5S%3DYh1h%3DoVY9A%40mail.gmail.com > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com