Gavin Sherry wrote:
Agreed, information_schema is database specific. I was thinking about a pg_tablespace_contents(..) function anyway.On Fri, 18 Jun 2004, Andreas Pflug wrote:
Gavin Sherry wrote:
I checked this to implement it, and found it being less then trivialOn 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|...} ?
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.
Being able to list all objects in a tablespace, including which databasesYou're suggesting the dblink way using a shell script. Imagine 20, 200, ... databases. This would be a costly thing (and has to be implemented differently in win32).
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.
I'd like to see an implementation that enables gui interfaces to show objects that depend on a tablespace, so you'd need to be aware of a user clicking on "show what's in that tablespace" and he probably wouldn't expect to wait an extended period of time for all databases to be scanned, or impose a 200-connection load on the server.
IMHO checking objects in a tablespace is a routine administrative task, so it should be supported natively by the server without need of contribs. And for win user acceptance, a command line tool won't be sufficient either.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]