|
12 | 12 | *by PostgreSQL |
13 | 13 | * |
14 | 14 | * IDENTIFICATION |
15 | | - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.531 2009/03/26 22:26:07 petere Exp $ |
| 15 | + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.532 2009/04/01 18:54:27 tgl Exp $ |
16 | 16 | * |
17 | 17 | *------------------------------------------------------------------------- |
18 | 18 | */ |
@@ -1995,7 +1995,13 @@ dumpBlobComments(Archive *AH, void *arg) |
1995 | 1995 | selectSourceSchema("pg_catalog"); |
1996 | 1996 |
|
1997 | 1997 | /* Cursor to get all BLOB comments */ |
1998 | | -if (AH->remoteVersion >=70200) |
| 1998 | +if (AH->remoteVersion >=70300) |
| 1999 | +blobQry="DECLARE blobcmt CURSOR FOR SELECT loid, " |
| 2000 | +"obj_description(loid, 'pg_largeobject') " |
| 2001 | +"FROM (SELECT DISTINCT loid FROM " |
| 2002 | +"pg_description d JOIN pg_largeobject l ON (objoid = loid) " |
| 2003 | +"WHERE classoid = 'pg_largeobject'::regclass) ss"; |
| 2004 | +elseif (AH->remoteVersion >=70200) |
1999 | 2005 | blobQry="DECLARE blobcmt CURSOR FOR SELECT loid, " |
2000 | 2006 | "obj_description(loid, 'pg_largeobject') " |
2001 | 2007 | "FROM (SELECT DISTINCT loid FROM pg_largeobject) ss"; |
|