Andreas Pflug wrote:
Joe Conway <mail@joeconway.com>
Andreas Pflug wrote: From an idea of Bruce, the attached patch implements the function pg_tablespace_databases(oid) RETURNS SETOF oid which delivers as set of database oids having objects in the selected tablespace, enabling an admin to examine only the databases affecting the tablespace for objects instead of scanning all of them. initdb forced
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +20 −1 |
| src/backend/commands/tablespace.c | modified | +2 −2 |
| src/backend/utils/adt/misc.c | modified | +100 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +4 −1 |
| src/include/utils/builtins.h | modified | +2 −1 |