Search Postgresql Archives

Re: psql "\d" no longer working

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2/12/23 08:49, Ron wrote:
On 2/12/23 03:02, Rob Sargent wrote:



    2023-02-10 13:42:55.214 MST [524159] STATEMENT:  SELECT
    c.relchecks, c.relkind, c.relhasindex, c.relhasrules,
    c.relhastriggers, c.relhasoids, '', c.reltablespace, CASE WHEN
    c.reloftype = 0 THEN '' ELSE
    c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence
            FROM pg_catalog.pg_class c
             LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid =
    tc.oid)
            WHERE c.oid = '219319';
    2023-02-10 13:43:01.143 MST [524159] ERROR:  column c.relhasoids
    does not exist at character 80

but I don't see any other issue in the log file.

I have yet to find another broken meta-command and no sql of mine has failed along similar lines as had "\d"

Any pointers much appreciated.


What is your search_path set to?

I doubt that is the problem as the issue is the column in the table not finding the table. pg_class.relhasoids no longer exists 12+, so the post from Georg is probably pointing in the right direction.


--
Born in Arizona, moved to Babylonia.

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux