| From: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org |
| Subject: | Can't access tables. |
| Date: | 2010-10-06 06:45:25 |
| Message-ID: | AANLkTinWHJn+9BxR1XOcqw8LLxru6MyXEUEV0kiVkTkx@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin |
Hello,
I have a problem with viewing tables from my DB. The interesting thing
is that the physical files exist in the data folder but only some of
them are visible both in pgAdmin and the application that uses the DB.
What's more there's no trace of those tables in pg_class whatsoever. I
can view ca. half of the tables (120 out of almost 250). Have anyone
come accross such behaviour? The files appear to be fine compared to
another DB containing same tables and same data.
--
Łukasz Brodziak
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bouiron olivier | 2010-10-06 08:06:11 | Better view of a request's result |
| Previous Message | Guillaume Lelarge | 2010-10-06 06:33:35 | Re: Bug: View Filtered Table Data Dialog |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julius Tuskenis | 2010-10-06 11:45:44 | Re: query execution time |
| Previous Message | Greg Smith | 2010-10-06 04:41:51 | Re: vacuum full table - internals in 8.3 |