From: | Shamik Majumder <shamik(dot)majumder(at)wipro(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Need help |
Date: | 2002-01-01 11:51:12 |
Message-ID: | 3C31A2AF.B15798EE@wipro.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-sql |
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
Attachment | Content-Type | Size |
---|---|---|
InterScan_Disclaimer.txt | text/plain | 855 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Sipos Andras | 2002-01-01 19:15:45 | posgreSql doesn't start |
Previous Message | Bob Smith, Hammett & Edison, Inc. | 2002-01-01 01:22:38 | VACUUM question, OID range |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2002-01-01 14:48:09 | problems using mod_auth_pgsql |
Previous Message | Thomas Lockhart | 2002-01-01 01:49:56 | Re: 7.2 changes to varchar truncation |
From | Date | Subject | |
---|---|---|---|
Next Message | Calvin Dodge | 2002-01-01 23:50:06 | Re: PostgreSQL SELECT error |
Previous Message | Tom Lane | 2001-12-31 16:02:47 | Re: Unpredictable text -> date implicit casting behaviour/to_date bug |