diff options
| author | Itagaki Takahiro <itagaki.takahiro@gmail.com> | 2009-12-14 00:39:11 +0000 |
|---|---|---|
| committer | Itagaki Takahiro <itagaki.takahiro@gmail.com> | 2009-12-14 00:39:11 +0000 |
| commit | 84f910a7076e09e551bf69e0972473ec15d33c79 (patch) | |
| tree | 7ce85524e7d24091581b2a0ce6309422d0330811 /contrib/vacuumlo | |
| parent | 0182d6f646997e486f56f847001ff74694bdd7da (diff) | |
| download | postgresql-84f910a7076e09e551bf69e0972473ec15d33c79.tar.gz | |
Additional fixes for large object access control.
Use pg_largeobject_metadata.oid instead of pg_largeobject.loid
to enumerate existing large objects in pg_dump, pg_restore, and
contrib modules.
Diffstat (limited to 'contrib/vacuumlo')
| -rw-r--r-- | contrib/vacuumlo/vacuumlo.c | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/contrib/vacuumlo/vacuumlo.c b/contrib/vacuumlo/vacuumlo.c index a0a7d57922..196688ce00 100644 --- a/contrib/vacuumlo/vacuumlo.c +++ b/contrib/vacuumlo/vacuumlo.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.42 2009/07/13 22:56:30 momjian Exp $ + * $PostgreSQL: pgsql/contrib/vacuumlo/vacuumlo.c,v 1.43 2009/12/14 00:39:10 itagaki Exp $ * *------------------------------------------------------------------------- */ @@ -142,7 +142,10 @@ vacuumlo(char *database, struct _param * param) */ buf[0] = '\0'; strcat(buf, "CREATE TEMP TABLE vacuum_l AS "); - strcat(buf, "SELECT DISTINCT loid AS lo FROM pg_largeobject "); + if (PQserverVersion(conn) >= 80500) + strcat(buf, "SELECT oid AS lo FROM pg_largeobject_metadata"); + else + strcat(buf, "SELECT DISTINCT loid AS lo FROM pg_largeobject"); res = PQexec(conn, buf); if (PQresultStatus(res) != PGRES_COMMAND_OK) { |