Can't find a relation in pg_class

Поиск
Список
Период
Сортировка
От Ron
Тема Can't find a relation in pg_class
Дата
Msg-id b7852f9d-e530-2ae6-f77b-2c17f3eed414@gmail.com
обсуждение исходный текст
Ответы Re: Can't find a relation in pg_class
Список 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 по дате отправления:

Предыдущее
От: pgsql-admin@kolttonen.fi
Дата:
Сообщение: The current shape of PG master-slave replication
Следующее
От: Payal Singh
Дата:
Сообщение: Re: The current shape of PG master-slave replication