Wow, this looks great, and it worked the first time too.  I will commit
if no one makes objects.


> > > > Is there a way to relate this to the names of the databases?  Why the
> > > > change?  Or am I missing something key here..
> > >
> > > See the thread on the renaming in the archives.  In short, this is part
> > > of Vadim's work on WAL -- the new naming makes certain things easier for
> > > WAL.
> > >
> > > Utilities to relate the new names to the actual database/table names
> > > _do_ need to be written, however.  The information exists in one of the
> > > system catalogs now -- it just has to be made accessible.
> >
> > Yes, I am hoping to write this utility before 7.1 final.  Maybe it will
> > have to be in /contrib.
> 
> I just finished writing such an app.  Take a look.  It's in a format
> that can be put in /contrib.  Let me know if you want any changes made,
> etc.  Feel free to use any of the code you wish.
> 
> http://www.crimelabs.net/postgresql.shtml
> 
> - Brandon
> 
> b. palmer,  bpalmer@crimelabs.net
> pgp:  www.crimelabs.net/bpalmer.pgp5
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 17 Jan 2001 17:49:36 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: $PGDATA/base/???
On Wed, Jan 17, 2001 at 05:49:36PM -0500, Bruce Momjian wrote:
> Wow, this looks great, and it worked the first time too.  I will commit
> if no one makes objects.
> 

I object. The code displays oids and tablenames or relnames. Oid is just
the initial, default filename for tables, and may change to something other
than the oid. Currently, the reindex code is the only place that could change
the relfilenode without changing the oid, but I think there may be more
in the future.

Here's a patch to Brandon's code (completely untested, BTW):

Ross
Wed, 17 Jan 2001 17:27:59 -0600
"Ross J. Reedstrom" <reedstrm@rice.edu>
Re: $PGDATA/base/???
> I object. The code displays oids and tablenames or relnames. Oid is just
> the initial, default filename for tables, and may change to something other
> than the oid. Currently, the reindex code is the only place that could change
> the relfilenode without changing the oid, but I think there may be more
> in the future.

Looks great,  and I agree.  Did not know that little piece of information.
I have made the changed to my code,  here's the new version.  I have
tested this one and updated the web page.

- brandon


b. palmer,  bpalmer@crimelabs.net
pgp:  www.crimelabs.net/bpalmer.pgp5
Wed, 17 Jan 2001 18:58:44 -0500 (EST)
bpalmer <bpalmer@crimelabs.net>
Re: $PGDATA/base/???
"Ross J. Reedstrom" <reedstrm@rice.edu> writes:
> I object. The code displays oids and tablenames or relnames. Oid is just
> the initial, default filename for tables, and may change to something other
> than the oid. Currently, the reindex code is the only place that could change
> the relfilenode without changing the oid, but I think there may be more
> in the future.

Right, relfilenode is the thing to look at, not OID.  I believe we are
thinking of using relfilenode updates for a number of things in the
future --- CLUSTER and faster index rebuilds in VACUUM are two thoughts
that come to mind ...

			regards, tom lane

Wed, 17 Jan 2001 20:44:27 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: $PGDATA/base/??? 
I have added this to /contrib for 7.1.

> > I object. The code displays oids and tablenames or relnames. Oid is just
> > the initial, default filename for tables, and may change to something other
> > than the oid. Currently, the reindex code is the only place that could change
> > the relfilenode without changing the oid, but I think there may be more
> > in the future.
> 
> Looks great,  and I agree.  Did not know that little piece of information.
> I have made the changed to my code,  here's the new version.  I have
> tested this one and updated the web page.
> 
> - brandon
> 
> 
> b. palmer,  bpalmer@crimelabs.net
> pgp:  www.crimelabs.net/bpalmer.pgp5
> 
Content-Description: 

[ Attachment, skipping... ]


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 23 Jan 2001 22:39:09 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: $PGDATA/base/???
On Tue, 23 Jan 2001, Bruce Momjian wrote:

> I have added this to /contrib for 7.1.
>
Not sure if you know this,  but you checked in the code compiled and w/
the .o file...

FYI.

b. palmer,  bpalmer@crimelabs.net
pgp:  www.crimelabs.net/bpalmer.pgp5


Tue, 23 Jan 2001 23:19:56 -0500 (EST)
bpalmer <bpalmer@crimelabs.net>
Re: $PGDATA/base/???
Thanks.  Removed.

> On Tue, 23 Jan 2001, Bruce Momjian wrote:
> 
> > I have added this to /contrib for 7.1.
> >
> Not sure if you know this,  but you checked in the code compiled and w/
> the .o file...
> 
> FYI.
> 
> b. palmer,  bpalmer@crimelabs.net
> pgp:  www.crimelabs.net/bpalmer.pgp5
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 24 Jan 2001 00:06:06 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: $PGDATA/base/???