Re: Why there is no records?
Christoph Moench-Tegeder <cmt@burggraben.net>
From: Christoph Moench-Tegeder <cmt@burggraben.net>
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-02-17T00:03:43Z
Lists: pgsql-general
## Igor Korot (ikorot01@gmail.com): > draft=# SELECT n.nspname, c.oid FROM pg_constraint c, pg_namespace n > WHERE c.oid = n.oid AND c.conname = 'leagues_pkey'; Because you're joining on the wrong column, see 3rd row of https://www.postgresql.org/docs/current/catalog-pg-constraint.html Regards, Christoph -- Spare Space