Re: Why there is no records?

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Why there is no records?
Date: 2026-02-17 00:03:43
Message-ID: aZOwX5CU7DgHvzx9@elch.exwg.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Igor Korot (ikorot01(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2026-02-17 00:03:46 Re: Why there is no records?
Previous Message Igor Korot 2026-02-16 23:59:46 Why there is no records?