pg_total_relation_size() could not open relation with OID X

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема pg_total_relation_size() could not open relation with OID X
Дата
Msg-id 20050929042516.GA29525@winnie.fuhr.org
обсуждение исходный текст
Ответы Re: pg_total_relation_size() could not open relation with OID X  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Here's a test case for a pg_total_relation_size() failure:

test=> CREATE TABLE foo (id integer);
CREATE TABLE
test=> SELECT oid, relfilenode FROM pg_class WHERE relname = 'foo'; oid  | relfilenode 
-------+-------------26235 |       26235
(1 row)

test=> SELECT pg_total_relation_size('foo');pg_total_relation_size 
------------------------                     0
(1 row)

test=> TRUNCATE foo;
TRUNCATE TABLE
test=> SELECT oid, relfilenode FROM pg_class WHERE relname = 'foo'; oid  | relfilenode 
-------+-------------26235 |       26237
(1 row)

test=> SELECT pg_total_relation_size('foo');
ERROR:  could not open relation with OID 26237
test=> SELECT pg_total_relation_size(26235);
ERROR:  could not open relation with OID 26237
test=> SELECT pg_relation_size('foo');pg_relation_size 
------------------               0
(1 row)

-- 
Michael Fuhr


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Open items list
Следующее
От: "Jeffrey W. Baker"
Дата:
Сообщение: Re: [PERFORM] A Better External Sort?