Strange "missing tables" problem

From: Denis BUCHER <dbucherml(at)hsolutions(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange "missing tables" problem
Date: 2009-08-23 12:26:06
Message-ID: 4A91355E.7010503@hsolutions.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis BUCHER 2009-08-23 12:32:42 Re: Strange "missing tables" problem
Previous Message Oleg Bartunov 2009-08-23 07:28:43 Re: Improving Full text performance