Skip site navigation (1) Skip section navigation (2)

Re: Tablespace patch review

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>,pgsql-patches(at)postgresql(dot)org
Subject: Re: Tablespace patch review
Date: 2004-06-19 02:08:28
Message-ID: 8286.1087610908@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> How useful will oid2name be if it doesn't understand about tablespaces?
>> I dunno how it ought to be changed, but surely it needs some thought.

> I assume we just need to add a tablespace display when run with no args,
> and a -s option to display _with_ -d to display only objects in that
> database.  We could go fancy and spin through all the databases and list
> the datbase name and objects in that tablespace.

I should think that the table-level display ought to show both the
relfilenode and tablespace OIDs for each table.

> Given the number of open items for 7.5, I am thinking of keeping this
> for post-feature freeze.  Both are contrib.

Right, I doubt Marc will object to fixing contrib stuff after feature
freeze ...

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Gavin SherryDate: 2004-06-19 02:10:00
Subject: Re: Minor DROP TABLESPACE issue
Previous:From: Tom LaneDate: 2004-06-19 02:04:44
Subject: Re: Minor DROP TABLESPACE issue

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-06-19 02:20:57
Subject: Re: Tablespace patch review
Previous:From: Bruce MomjianDate: 2004-06-19 01:47:43
Subject: Re: Tablespace patch review

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group