Can't find a relation in pg_class - Mailing list pgsql-admin

From Ron
Subject Can't find a relation in pg_class
Date
Msg-id b7852f9d-e530-2ae6-f77b-2c17f3eed414@gmail.com
Whole thread Raw
Responses Re: Can't find a relation in pg_class  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,

v9.6.6

10.143.169.100(38184) TAP TAPb 14310 PARSE waiting [unknown] 00000
       LOG:  process 14310 still waiting for AccessShareLock
       on relation 767445914 of database 767442254 after 1000.389 ms at character 39

We found this in the log file, so went looking for what relation 767445914 is, but don't see it in the pg_class table.  Am I doing something wrong?

postgres=# select oid, datname from pg_database;
    oid    |  datname
-----------+-----------
     13269 | postgres
         1 | template1
     13268 | template0
 767442254 | TAPb
(4 rows)

postgres=# \c TAPb

TAPb=# select n.nspname,
              c.relname,
              c.relfilenode
       from pg_class c,
               pg_namespace n
       where n.oid = c.relnamespace
         and c.relfilenode > 767445900
       order by c.relfilenode;
  nspname |                          relname                          | relfilenode
----------+-----------------------------------------------------------+-------------
 css      | branding_file_branding_file_id_seq                        |   767445903
 css      | cssbatch_control_cssbatch_control_id_seq                  |   767445920
 css      | cssdata_partition_ds_cssdata_partition_ds_id_seq          |   767447650
 css      | cssdata_partition_policy_cssdata_partition_policy_id_seq  |   767447655
[snip]

Thanks

--
Angular momentum makes the world go 'round.

pgsql-admin by date:

Previous
From: pgsql-admin@kolttonen.fi
Date:
Subject: The current shape of PG master-slave replication
Next
From: Payal Singh
Date:
Subject: Re: The current shape of PG master-slave replication