Re: Strange "missing tables" problem - Mailing list pgsql-general

From Denis BUCHER
Subject Re: Strange "missing tables" problem
Date
Msg-id 4A913C1F.4030209@hsolutions.ch
Whole thread Raw
In response to Re: Strange "missing tables" problem  (Wojtek <foo@twine.pl>)
Responses Re: Strange "missing tables" problem  (Denis BUCHER <dbucherml@hsolutions.ch>)
Re: Strange "missing tables" problem  ("Bill Bartlett" <bbartlett@softwareanalytics.com>)
List pgsql-general
Hello,

That's what I found, do you see something inside that looks interesting ?

bw_rma=# SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers';
 relname | relnamespace | reltype | relowner | relam | relfilenode |
reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid |
relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers
| relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules
| relhassubclass |                          relacl

---------+--------------+---------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+----------------------------------------------------------
 customers |        17013 |   17022 |       10 |     0 |       17021 |
           0 |    16202 |     86685 |             0 |             0 | f
          | f           | r       |        9 |         0 |           0 |
       0 |        0 |       0 | f          | f          | f           |
f              | {postgres=arwdRxt/postgres,as400=arwdRxt/postgres}
 customers |        17055 |   16398 |       10 |     0 |       16397 |
           0 |     2831 |     80929 |             0 |             0 | t
          | f           | r       |        9 |         0 |           0 |
       0 |        0 |       0 | f          | f          | f           |
f              | {postgres=arwdRxt/postgres,rma_php=r/postgres}
(2 lignes)

bw_rma=# SELECT * FROM pg_catalog.pg_tables WHERE tablename = 'customers';
   schemaname    | tablename | tableowner | tablespace | hasindexes |
hasrules | hastriggers
-----------------+-----------+------------+------------+------------+----------+-------------
 bw_import_as400 | clients   | postgres   |            | f          | f
       | f
 rma             | clients   | postgres   |            | t          | f
       | f
(2 lignes)

Thanks a lot for your help :-)

Denis

Wojtek a écrit :
> hi,
>
> You may try checking:
> SELECT * FROM pg_catalog.pg_class WHERE relname = 'customers'
> SELECT * FROM pg_catalog.pg_tables WHERE tablename = 'customers'
> to what's the status of your table.
>
> Regards,
> foo
>
> Denis BUCHER wrote:
>> Hello,
>>
>> Small correction to my previous email :
>>
>>
>>> I have a strange problem since I moved some tables to a schema, some
>>> tables are missing from the list (with \d or \dt) but they are still
>>> present anyway ???!!!!!
>>>
>>> Example :
>>>
>>>> $ psql mybase
>>>> Bienvenue dans psql 8.1.17, l'interface interactive de PostgreSQL.
>>>> Saisissez:
>>>> mybase=#
>>>> bw_rma=# \dt
>>>>                         Liste des relations
>>>>      Schéma      |           Nom            | Type  | Propriétaire
>>>> -----------------+--------------------------+-------+--------------
>>>>  import          | rebates_products         | table | postgres
>>>>  import          | rebates_customers        | table | postgres
>>>>  rma             | categories               | table | postgres
>>>>  rma             | customers                | table | postgres
>>>>  rma             | defauts                  | table | postgres
>>>>  rma             | providers                | table | postgres
>>>>
>>> No trace of my import.customers table ?????
>>>
>>> But if I do :
>>>
>>>> bw_rma=# SELECT count(*) FROM import.customers;
>>>>  count
>>>> -------
>>>>  86703
>>>> (1 ligne)
>>>>
>>> My table is there and I can access it !!!
>>>
>>> Any hint or help would be greatly appreciated !
>>>
>>> I can do without it, but it's a little strange not to be able to list
>>> the objects present in the database...

pgsql-general by date:

Previous
From: Wojtek
Date:
Subject: Re: Strange "missing tables" problem
Next
From: Jeff Ross
Date:
Subject: Re: Multiple table entries?