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

From Denis BUCHER
Subject Re: Strange "missing tables" problem
Date
Msg-id 4A914B81.2060204@hsolutions.ch
Whole thread Raw
In response to Re: Strange "missing tables" problem  (Wojtek <foo@twine.pl>)
List pgsql-general
Hello,


Wojtek a écrit :
>> It's even more strange :
>>
> why, looks logical to me :)
>> # \dt customers
>>            Liste des relations
>>  Schéma |   Nom   | Type  | Propriétaire
>> --------+---------+-------+--------------
>>  rma    | customers | table | postgres
>> (1 ligne)
>>
> you have 1 'customers' table in 'rma' schema and (my guess) currently
> you're connected as main user for this schema

Yes but why the import.customers table doesn't appear, then ?

>> # \dt import.customers
>>                Liste des relations
>>      Schéma      |   Nom   | Type  | Propriétaire
>> -----------------+---------+-------+--------------
>>  import          | customers | table | postgres
>> (1 ligne)
>>
>>
> you have 1 'customers' table in 'import' schema
>> # \dt *.customers
>>                Liste des relations
>>      Schéma      |   Nom   | Type  | Propriétaire
>> -----------------+---------+-------+--------------
>>  import          | customers | table | postgres
>>  rma             | customers | table | postgres
>> (2 lignes)
>>
>>
> you have two tables 'customers', one in schema 'import', the other one
> in schema 'rma'

Yes that's correct

> I assume you want to keep two copies of this table, right?

Yes, in fact they are two different tables...

Denis

pgsql-general by date:

Previous
From: Wojtek
Date:
Subject: Re: Strange "missing tables" problem
Next
From: Denis BUCHER
Date:
Subject: Re: Strange "missing tables" problem