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

Re: Tablespace patch review

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Tablespace patch review
Date: 2004-06-18 22:12:51
Message-ID: Pine.LNX.4.58.0406190809570.9333@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Fri, 18 Jun 2004, Andreas Pflug wrote:

> Gavin Sherry wrote:
>
> >On Fri, 18 Jun 2004, Bruce Momjian wrote:
> >
> >[snip]
> >
> >
> >
> >>>TODO.  You sound like a man who's expecting a
> >>>several-generations-polished facility when we only just committed
> >>>the first version today.  I do not feel a need to have any of these
> >>>features in 7.5 ...
> >>>
> >>>
> >>I just need to know what to add to the TODO list, and so we can answer
> >>people who are going to ask for this functionality.  Added to TODO:
> >>
> >>	* Allow reporting of which objects are in which tablespaces
> >>
> >>
> >
> >Do we need an information_schema.tablespaces view as well as an update to
> >information_schema.{tables|indexes|...} ?
> >
>
> I checked this to implement it, and found it being less then trivial
> when *all* objects of a tablespace should be displayed, not just the
> ones in the current database.

I don't think we should try and show all objects for a tablespace in
information_schema. That, as you point out, is hard and possibly gets
users into some messy situations.

Being able to list all objects in a tablespace, including which databases
they are in, is clearly useful, however (eg: hunting down use of a give
tablespace that you want dropped). Sounds like a script in contrib (or the
main source tree?) to me.

Gavin

In response to

Responses

pgsql-hackers by date

Next:From: Abhijit Menon-SenDate: 2004-06-18 22:13:23
Subject: Re: specifying multiple result format codes with libpq
Previous:From: Andreas PflugDate: 2004-06-18 21:54:22
Subject: Re: Tablespace patch review

pgsql-patches by date

Next:From: Tom LaneDate: 2004-06-18 22:14:15
Subject: Re: Tablespace patch review
Previous:From: Andreas PflugDate: 2004-06-18 21:54:22
Subject: Re: Tablespace patch review

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