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

Hello,

It's even more strange :

# \dt customers
           Liste des relations
 Schéma |   Nom   | Type  | Propriétaire
--------+---------+-------+--------------
 rma    | customers | table | postgres
(1 ligne)

# \dt import.customers
               Liste des relations
     Schéma      |   Nom   | Type  | Propriétaire
-----------------+---------+-------+--------------
 import          | customers | table | postgres
(1 ligne)

# \dt *.customers
               Liste des relations
     Schéma      |   Nom   | Type  | Propriétaire
-----------------+---------+-------+--------------
 import          | customers | table | postgres
 rma             | customers | table | postgres
(2 lignes)

I really don't understand what's happening here ?

Denis

> That's what I found, do you see something inside that looks interesting ?
>
> # 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)
>
> # 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...
>