Two tables with same name in different user not allowed 
Author Message
 Two tables with same name in different user not allowed

Quote:

> Hi ,
>   I have two users in my database x & y.
> I tried to create a table abc in y which is there in x with the same
> name.Ofcourse i logged in as user y and tried.
> Even then am not allowed to create throwing error that "object already
> exist".
>   Can anybody xplain this comparing Oracle-schema with the user in postgres
> as am in the process of porting oracle schemas to postgres`.

We don't have schemas but hope to have them in 7.3.  Right now, you can
create temp tables with duplicate names but they go away on session
exit.

--
  Bruce Momjian                        |   http://www.***.com/

  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------



Sun, 25 Jul 2004 13:52:05 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Two tables with same name in different user not allowed ?

2. Open Two Database with Two System.Mda and Two different User Names and Password

3. Trying to bind data from two different tables to two different controls

4. Flawed Design of Allowing Same Table Name of Different Owner

5. Data Trans Service - license does not allow - import of table on different server

6. DELETE statement does not allow pseudo name for table

7. Different views with same name for different users

8. ...inner join query between two table of two different database

9. Join two tables from two different SQL databases

10. SQL Query - join two tables in two different databases

11. inner join query between two table of two different database

12. how to establish referntial integraty of a column with two different columns of different tables


 
Powered by phpBB® Forum Software