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 postgresql-0b89d261c7a91ff9ebc6a6b9bd3ee129576bdd9a.zip | |
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 847985456f7..875fb1cae8a 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) |