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 05:10:35
Message-ID: 9721.1087621835@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:
>> I should think that the table-level display ought to show both the
>> relfilenode and tablespace OIDs for each table.

> For objects in the default tablespace, they don't show a tablespace oid,
> right?  Where do we put it?  A column that will be empty if they don't
> use tablespaces?

pg_class will show a zero for objects in the default tablespace, but
I think oid2name should pull the actual tablespace ID from
pg_database.dattablespace and show that.  The convention about zero
is just to make life simple for CREATE DATABASE --- users of oid2name
should not have to think about it.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-06-19 05:17:34
Subject: Re: Tablespace patch review
Previous:From: Tom LaneDate: 2004-06-19 05:04:32
Subject: Re: Minor DROP TABLESPACE issue

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-06-19 05:13:55
Subject: Re: eventlog fix
Previous:From: Tom LaneDate: 2004-06-19 05:02:22
Subject: Re: Tablespace patch review

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