Re: [GENERAL] Need help

From: Jason Earl <jason(dot)earl(at)simplot(dot)com>
To: Shamik Majumder <shamik(dot)majumder(at)wipro(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [GENERAL] Need help
Date: 2002-01-08 17:17:03
Message-ID: 873d1g9300.fsf@npa01zz001.simplot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql


Why do you want a database where two tables have the same name? When
you do a "SELECT * from Table1" what table do you expect PostgreSQL to
use?

Now, that being said, it's possible to create temporary tables in
different connections with the same name. These tables will dissapear
when the connection is terminated, however. For example you could
have something like this:

conn1: CREATE TEMP TABLE foo (bar text);
conn2: CREATE TEMP TABLE foo (bar text);
conn1: INSERT INTO foo (bar) VALUES ('baz');
conn2: SELECT * from foo; [returns zero rows]
conn1: SELECT * from foo; [returns 'baz']

If you actually want two permanent tables with the same name, you are
going to have to put them in separate databases. Otherwise use
temporary tables.

Jason

Shamik Majumder <shamik(dot)majumder(at)wipro(dot)com> writes:

> 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
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

  • Need help at 2002-01-01 11:51:12 from Shamik Majumder

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-01-08 19:01:25 Re: problems with pg_sorttemp
Previous Message Manuel Trujillo 2002-01-08 15:48:57 problem with pg_sorttemp files

Browse pgsql-general by date

  From Date Subject
Next Message steve boyle 2002-01-08 17:24:40 Re: Grave performance issues...
Previous Message steve boyle 2002-01-08 17:11:07 Re: How to Reference Current Table Name in plpgsql Trigger?

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Bax 2002-01-08 19:03:19 Re: simple? join
Previous Message Terrence Brannon 2002-01-08 16:35:39 Momjian "Support Functions" section: possible typo and question