Message-ID: <3C31A2AF.B15798EE@wipro.com>
Date: Tue, 01 Jan 2002 17:21:12 +0530
From: Shamik Majumder <shamik.majumder@wipro.com>
Organization: Wipro
MIME-Version: 1.0
To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org,
	pgsql-sql@postgresql.org
Subject: Need help
Content-Type: multipart/mixed;
	boundary="----=_NextPartTM-000-6cd6523c-fead-11d5-a217-0000e22173f5"


This is a multi-part message in MIME format.

------=_NextPartTM-000-6cd6523c-fead-11d5-a217-0000e22173f5
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi ,

We are facing some problems with the creation of tables of same name but
owned by different user .

We followed the following steps .

Lets say, we have a database DBTest and this database was created by the
user postgres.
We created  tables - Table1, Table2 and Table3 in it.
Now, by using the createuser command - one more database user is
created, say dbuser1.
Now, when I login as dbuser1 on the DBTest database, I can see all the
tables Table1, Table2 and Table3 by /dt command.
Even, I am able to create new tables ( i.e table with new names ) in the
same database DBTest but with the owner dbuser1.
Now, when I try to create the same table like Table1 ( which has been
created by the
postgress user previously ) as dbuser1 user  - the create table command
fails with the following o/p :

ERROR:  Relation 'Table1' already exists

My question  - is it possible in Postgres, to create the tables with
same name but with different users ?

i.e we create Table1 table both as postgres as well as dbuser1 .

Is it possible kindly let me know .

Thanks and Regards,
Shamik


------=_NextPartTM-000-6cd6523c-fead-11d5-a217-0000e22173f5
Content-Type: text/plain;
	name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="InterScan_Disclaimer.txt"

-------------------------------------------------------------------------------------------------------------------------
Information transmitted by this E-MAIL is proprietary to Wipro and/or its Customers and
is intended for use only by the individual or entity to which it is
addressed, and may contain information that is privileged, confidential or
exempt from disclosure under applicable law. If you are not the intended
recipient or it appears that this mail has been forwarded to you without
proper authority, you are notified that any use or dissemination of this
information in any manner is strictly prohibited. In such cases, please
notify us immediately at mailto:mailadmin@wipro.com and delete this mail
from your records.
----------------------------------------------------------------------------------------------------------------------

------=_NextPartTM-000-6cd6523c-fead-11d5-a217-0000e22173f5--