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 1vwVpi-00BdDK-2E for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 01:42:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vwVph-00C5l7-1w for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 01:42:57 +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.96) (envelope-from ) id 1vwVph-00C5kz-0V for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 01:42:57 +0000 Received: from mail-ot1-x32a.google.com ([2607:f8b0:4864:20::32a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vwVpd-00000001rzh-48An for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 01:42:56 +0000 Received: by mail-ot1-x32a.google.com with SMTP id 46e09a7af769-7d4ba9abbecso4181751a34.1 for ; Sat, 28 Feb 2026 17:42:55 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772329374; cv=none; d=google.com; s=arc-20240605; b=CLHAdSiyxG5N6s/opbRiIpuagPu9jvnMpg/MU1h9ZUlaQeQfM9f+qiJ8imiC9+osIW 0dhRvYz0sqt0syiXPOnE9MV5zonnbXPO2LrOVIEwMaYRFvaGHc1VYdGBepSfQUtuRgh4 mU+TIGS6shra5yNOez1fpQ5y8gGai3FqZ9VFiikd32oY3jaddIN9E41FH/EkYR2RlZzW o5T1VVFvqWT2a6pYrUWBCNLnEE9FR6Qmo5b1AWlV60X9caRq8654k68GnwOID0tehmGE 29nNoILBWCX9eS0U3zzkbq6TI8hWaACU9dV1neScOB+MsyEg/mtjM1qNoT51ACyQ8Nbp Uonw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=ko8UzFzp/zkrxufXx4HuM/SdJ/E7ZaoVlGgwObEz/TY=; fh=MqX3/PjeIRWyveucHIwmT3MEzIvphFWgoM5FEnVDTkI=; b=bU0ZplQqMVauCiw04UqprATnpWOI1rTtQL+B35ptgAuaooJ1HNkclRb3L1EClFGSEP RMiOshhmBEL4EDWBOxEQFNwJ3jov+EGZN7+RBqyT43nJkU2degWuCskaUzqTLCCDC856 Ml5mhXVMLBGA8zkd6vMVh5mgQNULr/4fDWjlPD4kxOKgN+27hzCPhhtby9V1SUxGZ9ie Lazd9Rxz+1J/y713Cf2sbxz5VQ3rLsqp6OIf9sL+hbkTjV2YhIbQ2oP9XUQ2ilBP651x f6u05wTSohqAPQV6e/jaDHZrpm+RAz5bEGrk+Fcl2b/6Bo3dCuh5HJmH6A/Sbc8XoLz7 mdZg==; 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=1772329374; x=1772934174; 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=ko8UzFzp/zkrxufXx4HuM/SdJ/E7ZaoVlGgwObEz/TY=; b=AcIzKu7NVJEfw2gM3dpZ3/gKtFzWJHgfCfk9ocrTPJhGiv4+kXC7lpOJ1F8GcEoGZk 9WPXzENs1fKBhbMFj65b5/+lCQOgAresh/MXf6Ii1LvfT53HndcDtmEg8VdU/uziofLv yWfj3CT0KBNLec4rvAIWJ5suVcxRD3TJYvwIdq8WN9kiKTlhf5M/3cErNVZT5KW5oiUw W5hL/TRL6zSEk3DMfcFgGvfBVvdMXtqAdWcKKtBfQLAjWHBTNi80PbHUkDOfpuKrgOGb IIdQd8vEq8VGbiQIdBdLDarGhNPm2d3NxtrQ6Fa+Ia92VR4ooegKegQxnXohhEI9oKqy bEqw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772329374; x=1772934174; h=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=ko8UzFzp/zkrxufXx4HuM/SdJ/E7ZaoVlGgwObEz/TY=; b=EeJ5PW0lKQA7WSIA2PQRDa7wW3nWl4XHPpJZDK1NEtIczyUj6OOyZwCjoWsIhFYfBX UUV+gDgjU2abFheb17YZWgvGHisQDA11hm/T2jMiTL4COegJMW07JpeigcE2gHwR0lDS mJbX4j7FYqBGsO6yT9t182bTLAn7WNAGgb67BsEEZSTdmEdu96Mj0xg+A+oFfy7huZ2o R987ZhTE5AbE1IE16jDU7fLxO1poR4aEaCwRFh/S22e6SjUDRdYQ1VCtKYHaiFBgc1IB 488XpMmeWrOjIQ7LWh3r1WZHys4KbMsRIFlNSmxQ9QSfg7kir1RIL3inAgMibPzehxNH /pWQ== X-Gm-Message-State: AOJu0YxSNTQ6GfjJKIjTSsWb6xOGxIxqGkyNRSQ2U31OVeJLzrmgmOZw Iyo6mMHfZfUBeZsLFnpneadsXGBS8PVgfQH5elxh7s/+Nqj7HgTcZk4xb7g+3/xcPk6FJjvnY76 ead1fHfqcHZlzhlXh5w0FxCECyUFk/4c= X-Gm-Gg: ATEYQzxYNQQdSfZc0Rr3u6HWYyfv55Wk4tzHpVyBLj3YECVXMNMMEIkka4eDPyXf3GX SDdRxlsOstkBnheyhfArSNEodkDD2liMAFii+jkIMh7YHhCrtY5qcdgjX89gHKFZhyDNxrudHID 9ZS/ZdGJBP8vbTD+/TfwJLaGoRjwPmYiRLY0JU/p/szDqgbwzJ9ZJKVeO34Jk1iOcfdwvqEr/L9 EvmnGItqj8OC5DaYNy7vEZLiMxZOC8wmop+gaNHyDpb6bgbRS+kWmiowXd5GzHMDFgN0ruNvAcc L3E8USg= X-Received: by 2002:a05:6830:6987:b0:7c9:5934:85f0 with SMTP id 46e09a7af769-7d591bd10abmr5144400a34.23.1772329374529; Sat, 28 Feb 2026 17:42:54 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Sat, 28 Feb 2026 18:42:18 -0700 X-Gm-Features: AaiRm505M9D5-zErixThNslviv1leEOUuUFxdcyFJPFF5J1zQbSzlBqXCSegvHU Message-ID: Subject: Re: Where the info is stored To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000cb3b00064bec9653" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cb3b00064bec9653 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, Feb 28, 2026 at 6:34=E2=80=AFPM Igor Korot wro= te: > And why there is no WHERE populated? > > Thank you. > > On Sat, Feb 28, 2026 at 7:05=E2=80=AFPM Igor Korot w= rote: > > > > Hi, David, > > > > On Sat, Feb 28, 2026 at 7:02=E2=80=AFPM David G. Johnston > > wrote: > > > > > > On Saturday, February 28, 2026, Igor Korot wrote= : > > >> > > >> FROM pg_constraint co, pg_namespace n, pg_class > > >> > > >> As you can see only the constraint name and the tablespace are > > >> populated correctly. > > > > > > > > > Constraints don=E2=80=99t have included columns. Only indexes do. Y= ou need > to query the index, not the constraint. > > > > I literally copied your query into my code and it didn't populated > > anything... > > > > Am I missing something? > > I trimmed your query to emphasize/point-out that you were querying pg_constraint and that doing so to find included columns is doomed to failure (I suppose it could have been used to find the index, but in this case it wasn't. I haven't explored that approach.). You should step back and consider why you thought the fragment I included in my reply, a bare FROM clause, would somehow be executable since it is in no way a valid query. David J. --000000000000cb3b00064bec9653 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sat, Feb 28, 2026 at 6:34=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrote:=
And why there is no WHERE populated?
Thank you.

On Sat, Feb 28, 2026 at 7:05=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrote:
>
> Hi, David,
>
> On Sat, Feb 28, 2026 at 7:02=E2=80=AFPM David G. Johnston
> <da= vid.g.johnston@gmail.com> wrote:
> >
> > On Saturday, February 28, 2026, Igor Korot <ikorot01@gmail.com> wrote:
> >>
> >> FROM pg_constraint co, pg_namespace n, pg_class
> >>
> >> As you can see only the constraint name and the tablespace ar= e
> >> populated correctly.
> >
> >
> > Constraints don=E2=80=99t have included columns.=C2=A0 Only index= es do.=C2=A0 You need to query the index, not the constraint.
>
> I literally copied your query into my code and it didn't populated=
> anything...
>
> Am I missing something?


I trimm= ed your query to emphasize/point-out that you were querying pg_constraint a= nd that doing so to find included columns is doomed to failure (I suppose i= t could have been used to find the index, but in this case it wasn't.= =C2=A0 I haven't explored=C2=A0that approach.).=C2=A0 You should step b= ack and consider why you thought the fragment I included in my reply, a bar= e FROM clause, would somehow be executable since it is in no way a valid qu= ery.

David J.

--000000000000cb3b00064bec9653--