MIME-Version: 1.0
References: <CA+FnnTw9zGdkdhT75qzA-dWBzbQB+QrMB-sx=+bcLA72DoRSzQ@mail.gmail.com>
 <b5dc7960-520b-40e1-bba8-1a2db374ec8c@aklaver.com>
In-Reply-To: <b5dc7960-520b-40e1-bba8-1a2db374ec8c@aklaver.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Mon, 16 Feb 2026 18:15:23 -0600
Message-ID: <CA+FnnTyio1AUiz48jHwHXXgr149c=YMRObJeKci+rGF9BkvSrw@mail.gmail.com>
Subject: Re: Why there is no records?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTyio1AUiz48jHwHXXgr149c%3DYMRObJeKci%2BrGF9BkvSrw%40mail.gmail.com>
Precedence: bulk

Thx.

On Mon, Feb 16, 2026 at 6:03=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com> wrote:
>
> On 2/16/26 15:59, Igor Korot wrote:
> > Hi,
> >
> > draft=3D# SELECT n.nspname, c.oid FROM pg_constraint c, pg_namespace n
> > WHERE c.oid =3D n.oid AND c.conname =3D 'leagues_pkey';
>
> Because you are doing:
>
> c.oid =3D n.oid
>
> which is comparing the pg_constraint.oid to the pg_namespace.oid which
> are not the same thing.
>
> You need:
>
> c.connamespace =3D n.oid
>
>
> >   nspname | oid
> > ---------+-----
> > (0 rows)
> >
> > draft=3D# SELECT * FROM pg_constraint WHERE conname =3D 'leagues_pkey';
> >    oid  |   conname    | connamespace | contype | condeferrable |
> > condeferred | convalidated | conrelid | contypid | conindid |
> > conparentid | confrelid | confupdtype | confdeltype | confmatchtype |
> > conislocal | coninhcount | connoinherit | conkey | confkey | conpfeqop
> > | conppeqop | conffeqop | confdelsetcols | conexclop | conbin
> > -------+--------------+--------------+---------+---------------+-------=
------+--------------+----------+----------+----------+-------------+------=
-----+-------------+-------------+---------------+------------+------------=
-+--------------+--------+---------+-----------+-----------+-----------+---=
-------------+-----------+--------
> >   16395 | leagues_pkey |         2200 | p       | f             | f
> >        | t            |    16390 |        0 |    16394 |           0 |
> >         0 |             |             |               | t          |
> >         0 | t            | {1}    |         |           |           |
> >          |                |           |
> > (1 row)
> >
> > Thank you.
> >
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com