Re: wiki Disk Usage, table size: ERROR: could not open relation with OID 0

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Hans Schou <hans(dot)schou(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: wiki Disk Usage, table size: ERROR: could not open relation with OID 0
Date: 2018-03-14 23:32:38
Message-ID: 20180314233238.GB617@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 14, 2018 at 04:17:54PM +0100, Hans Schou wrote:
> I got the message
> ERROR: could not open relation with OID 0
> when running the "General Table Size Information" from
> https://wiki.postgresql.org/wiki/Disk_Usage

I cannot see this failure on latest HEAD on a database running the
regression database. This is an elog() message by the way, which is
something to report internal errors, so users should never be able to
face it.

> But I guess it was supposed to give size of all tables.
>
> I'm running version 9.1.9 so it should be working according to the
> wiki.

You should update and upgrade. 9.1 has fallen out of community support
1 year and a half ago, and 9.1.9 is utterly outdated.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-03-14 23:44:55 Re: wiki Disk Usage, table size: ERROR: could not open relation with OID 0
Previous Message Alexander Farber 2018-03-14 22:27:05 Re: Extract elements from JSON array and return them as concatenated string