MIME-Version: 1.0
From: Igor Korot <ikorot01@gmail.com>
Date: Mon, 16 Feb 2026 17:59:46 -0600
Message-ID: <CA+FnnTw9zGdkdhT75qzA-dWBzbQB+QrMB-sx=+bcLA72DoRSzQ@mail.gmail.com>
Subject: Why there is no records?
To: "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%2BFnnTw9zGdkdhT75qzA-dWBzbQB%2BQrMB-sx%3D%2BbcLA72DoRSzQ%40mail.gmail.com>
Precedence: bulk

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';
 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.