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.
There seem to be several ways to implement:
(1) dblink like access iterating all databases. This seems extraordinarily expensive
(2) low level scanning tablespace location, then try to translate found oids to names withoug SPI. Probably not desirable.
(3) extending parser/executor to allow a table specification of the form database.namespace.tablename. This has been requested several times before, but was rejected, with the advise to use dblink.
(4) Copy the contents of the desired cross-db table to a temporary table (generate new oid in local db, copy cross-db table file to new oid file, insert pg_class). A typically weird Andreas' approach :-)
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
