Received: from eufig1.rit.reuters.com (eufig1.rit.reuters.com [194.205.123.3])
	by postgresql.org (8.11.3/8.11.4) with SMTP id g099l5B59992;
	Wed, 9 Jan 2002 04:47:06 -0500 (EST)
	(envelope-from Maarten.Boekhold@reuters.com)
Received: from no.name.available by eufig1.rit.reuters.com
	via smtpd (for postgresql.org [64.49.215.8]) with SMTP;
	9 Jan 2002 09:47:58 UT
Received: from eupig1 (unverified) by reuters.com
	(Content Technologies SMTPRS 4.2.1) with ESMTP id
	<T58570dcd47c407b70647c@reuters.com>; Wed, 9 Jan 2002 09:47:24 +0000
Message-ID: <T58570dcd47c407b70647c@reuters.com>
Received: from eungw2.ime.reuters.com ([10.1.4.30])
	by eupig1.dtc.lon.ime.reuters.com (PMDF V5.2-32 #39917)
	with ESMTP id <0GPO00ESF0IB3D@eupig1.dtc.lon.ime.reuters.com>; Wed,
	9 Jan 2002 09:46:59 +0000 (GMT)
Date: Wed, 09 Jan 2002 13:47:03 +0400
From: Maarten.Boekhold@reuters.com
Subject: Re: [GENERAL] Need help
To: Jason Earl <jason.earl@simplot.com>
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org,
	pgsql-sql@postgresql.org, shamik.majumder@wipro.com
MIME-version: 1.0
X-Mailer: Lotus Notes Release 5.0.2b (Intl) 16 December 1999
Content-type: multipart/alternative;
	boundary="=_alternative 002E8C9A44256B3C_="
X-MIMETrack: Serialize by Router on EUNGW2/LON/GB/Reuters(Release 5.0.6a
	|January 17, 2001) at 09/01/2002 09:42:08 AM,
	Serialize complete at 09/01/2002 09:42:08 AM
X-Archive-Number: 200201/68
X-Sequence-Number: 2956

This is a multipart message in MIME format.
--=_alternative 002E8C9A44256B3C_=
Content-Type: text/plain; charset="us-ascii"

On 01/08/2002 09:17:03 PM Jason Earl wrote:
> 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?

I suspect Shamik is trying to do something like having a separate 'schema' 
(Oracle) for every user, and in Oracle it is possible to create tables 
with the same name but in different schemas.

Maarten

----

Maarten Boekhold, maarten.boekhold@reuters.com

Reuters Consulting / TIBCO Finance Technology Inc.
Dubai Media City
Building 1, 5th Floor
PO Box 1426
Dubai, United Arab Emirates
tel:+971(0)4 3918300 ext 249
fax:+971(0)4 3918333
mob:+971(0)505526539

-------------------------------------------------------------- --
        Visit our Internet site at http://www.reuters.com

Any views expressed in this message are those of  the  individual
sender,  except  where  the sender specifically states them to be
the views of Reuters Ltd.

--=_alternative 002E8C9A44256B3C_=
Content-Type: text/html; charset="us-ascii"




<br><font size=2 face="sans-serif">On 01/08/2002 09:17:03 PM Jason Earl wrote:<br>
&gt; Why do you want a database where two tables have the same name? &nbsp;When<br>
&gt; you do a &quot;SELECT * from Table1&quot; what table do you expect PostgreSQL to<br>
&gt; use?<br>
</font>
<br><font size=2 face="sans-serif">I suspect Shamik is trying to do something like having a separate 'schema' (Oracle) for every user, and in Oracle it is possible to create tables with the same name but in different schemas.</font>
<br>
<br><font size=2 face="sans-serif">Maarten</font>
<br><font size=2 face="sans-serif"><br>
----<br>
<br>
Maarten Boekhold, maarten.boekhold@reuters.com<br>
<br>
Reuters Consulting / TIBCO Finance Technology Inc.<br>
Dubai Media City<br>
Building 1, 5th Floor<br>
PO Box 1426<br>
Dubai, United Arab Emirates<br>
tel:+971(0)4 3918300 ext 249<br>
fax:+971(0)4 3918333<br>
mob:+971(0)505526539</font><CODE><FONT SIZE=3><BR>
<BR>
-------------------------------------------------------------- --<BR>
        Visit our Internet site at http://www.reuters.com<BR>
<BR>
Any views expressed in this message are those of  the  individual<BR>
sender,  except  where  the sender specifically states them to be<BR>
the views of Reuters Ltd.<BR>
</FONT></CODE>
--=_alternative 002E8C9A44256B3C_=--