| 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: | Whole Thread | Raw Message | 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
| 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 |