Re: what is in ../data/base ??

You wrote:

> See contrib/oid2name for mapping from numbers to names of databases and
> tables/indexes.

Great !!! just what I needed too.

On a side note Bryan White of pg_check fame did not respond to my mail concerning compile failure of pg_check. Is he still around???

I still have to recover data from the crash before Xmas and my client is getting impatient.

Cheers

Tony Grant

--
tony(at)animaproductions(dot)com

RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html
>From pgsql-general-owner(at)postgresql(dot)org Wed Jan 9 04:55:32 2002
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(dot)Boekhold(at)reuters(dot)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(at)reuters(dot)com>;
Wed, 9 Jan 2002 09:47:24 +0000
Message-ID: <T58570dcd47c407b70647c(at)reuters(dot)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(at)eupig1(dot)dtc(dot)lon(dot)ime(dot)reuters(dot)com>; Wed,
9 Jan 2002 09:46:59 +0000 (GMT)
Date: Wed, 09 Jan 2002 13:47:03 +0400
From: Maarten(dot)Boekhold(at)reuters(dot)com
Subject: Re: Need help
To: Jason Earl <jason(dot)earl(at)simplot(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org,
pgsql-sql(at)postgresql(dot)org, shamik(dot)majumder(at)wipro(dot)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/227
X-Sequence-Number: 19189

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(dot)boekhold(at)reuters(dot)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(dot)boekhold(at)reuters(dot)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_=--