diff options
author | Joe Conway <mail@joeconway.com> | 2004-07-02 18:59:25 +0000 |
---|---|---|
committer | Joe Conway <mail@joeconway.com> | 2004-07-02 18:59:25 +0000 |
commit | 0b89d261c7a91ff9ebc6a6b9bd3ee129576bdd9a (patch) | |
tree | be0e9be6e1964c6c5b8d6776b2a266a88cfdf068 /src/backend/commands/tablespace.c | |
parent | 6d6c8b0d96a75f804d49f046f2fad8c60ea55fbe (diff) | |
download | postgresql-0b89d261c7a91ff9ebc6a6b9bd3ee129576bdd9a.tar.gz |
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
Diffstat (limited to 'src/backend/commands/tablespace.c')
-rw-r--r-- | src/backend/commands/tablespace.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/commands/tablespace.c b/src/backend/commands/tablespace.c index 847985456f..875fb1cae8 100644 --- a/src/backend/commands/tablespace.c +++ b/src/backend/commands/tablespace.c @@ -45,7 +45,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/commands/tablespace.c,v 1.4 2004/06/25 21:55:53 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/commands/tablespace.c,v 1.5 2004/07/02 18:59:22 joe Exp $ * *------------------------------------------------------------------------- */ @@ -315,7 +315,7 @@ CreateTableSpace(CreateTableSpaceStmt *stmt) /* * All seems well, create the symlink */ - linkloc = (char *) palloc(strlen(DataDir) + 16 + 10 + 1); + linkloc = (char *) palloc(strlen(DataDir) + 11 + 10 + 1); sprintf(linkloc, "%s/pg_tblspc/%u", DataDir, tablespaceoid); if (symlink(location, linkloc) < 0) |