|
12 | 12 | *by PostgreSQL |
13 | 13 | * |
14 | 14 | * IDENTIFICATION |
15 | | - * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.386 2004/08/29 05:06:53 momjian Exp $ |
| 15 | + * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.387 2004/10/06 17:43:07 momjian Exp $ |
16 | 16 | * |
17 | 17 | *------------------------------------------------------------------------- |
18 | 18 | */ |
@@ -1395,15 +1395,15 @@ dumpBlobs(Archive *AH, void *arg) |
1395 | 1395 |
|
1396 | 1396 | /* Cursor to get all BLOB tables */ |
1397 | 1397 | if (AH->remoteVersion >=70100) |
1398 | | -appendPQExpBuffer(oidQry,"Declare blobOid Cursor for SELECT DISTINCT loid FROM pg_largeobject"); |
| 1398 | +appendPQExpBuffer(oidQry,"DECLARE bloboid CURSOR FOR SELECT DISTINCT loid FROM pg_largeobject"); |
1399 | 1399 | else |
1400 | | -appendPQExpBuffer(oidQry,"Declare blobOid Cursor for SELECT oid from pg_class where relkind = 'l'"); |
| 1400 | +appendPQExpBuffer(oidQry,"DECLARE bloboid CURSOR FOR SELECT oid from pg_class where relkind = 'l'"); |
1401 | 1401 |
|
1402 | 1402 | res=PQexec(g_conn,oidQry->data); |
1403 | 1403 | check_sql_result(res,g_conn,oidQry->data,PGRES_COMMAND_OK); |
1404 | 1404 |
|
1405 | 1405 | /* Fetch for cursor */ |
1406 | | -appendPQExpBuffer(oidFetchQry,"Fetch %din blobOid",loFetchSize); |
| 1406 | +appendPQExpBuffer(oidFetchQry,"FETCH %dIN bloboid",loFetchSize); |
1407 | 1407 |
|
1408 | 1408 | do |
1409 | 1409 | { |
|