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

This is a multi-part message in MIME format.

--------------InterScan_NT_MIME_Boundary
Content-Type: text/plain; charset="iso-8859-1"

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

thanks
laks

--------------InterScan_NT_MIME_Boundary
Content-Type: text/plain; name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="InterScan_Disclaimer.txt"

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

                Visit us at http://www.***.com/

--------------InterScan_NT_MIME_Boundary
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
MIME-Version: 1.0

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly

--------------InterScan_NT_MIME_Boundary--



Sun, 25 Jul 2004 13:10:11 GMT
 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`.

PostgreSQL 7.2 does not support schema like that.
I believe that they plan on having some support
for that in 7.3

For 7.2, you create separate databases, perhaps named
after your users. Unfortunately, you cannot perform
queries across multiple databases. What is it you
need to do, and maybe someone here can help you find
a work-around.



Mon, 26 Jul 2004 11:11:58 GMT
 
 [ 2 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. view of two table with two different indexes

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

10. Quering two tables in two different files

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

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


 
Powered by phpBB® Forum Software