| From: | Rajarshi Guha <rguha(at)indiana(dot)edu> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | tables are not listable by \dt |
| Date: | 2007-07-02 14:04:21 |
| Message-ID: | 1454C9ED-2B72-4D4F-A406-B650488EE2A3@indiana.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, we recently upgraded our Postgres instllation from 7.4 to 8.2 by
doing a dump and restore. Howveer after logging into the database (as
a user that is not the superuser) and doing \dt I get the error:
No relations found
But when I do
SELECT relname, relpages FROM pg_class ORDER BY relpages DESC;
I get a list of the tables and their sizes.
I'm not even sure where to begin looking for the solution and any
pointers would be much appreciated.
-------------------------------------------------------------------
Rajarshi Guha <rguha(at)indiana(dot)edu>
GPG Fingerprint: 0CCA 8EE2 2EEB 25E2 AB04 06F7 1BB9 E634 9B87 56EE
-------------------------------------------------------------------
A mathematician is a device for turning coffee into theorems.
-- P. Erdos
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-07-02 14:47:51 | Re: ERROR: unexpected hash relation size: |
| Previous Message | Michael Fuhr | 2007-07-02 13:31:04 | Re: shmctl EIDRM preventing startup |