Search Postgresql Archives

Strange "missing tables" problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

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.clients 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...

Denis


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux