Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
remove 'with hold' from postgres cursors
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@9095 c8812cc2-4d05-0410-92ff-de0c093fc19c
  • Loading branch information
jef committed Aug 20, 2008
1 parent 1421642 commit 57c508f
Showing 1 changed file with 2 additions and 2 deletions.
4 changes: 2 additions & 2 deletions src/providers/postgres/qgspostgresprovider.cpp
Expand Up @@ -383,7 +383,7 @@ bool QgsPostgresProvider::declareCursor(const QString &cursorName,
{
try
{
QString declare = QString("declare %1 binary cursor with hold for select %2")
QString declare = QString("declare %1 binary cursor for select %2")
.arg(cursorName).arg(quotedIdentifier(primaryKey));

if(fetchGeometry)
Expand Down Expand Up @@ -2434,7 +2434,7 @@ bool QgsPostgresProvider::deduceEndian()

// get the same value using a binary cursor

QString oidDeclare = QString("declare oidcursor binary cursor with hold for select regclass(%1)::oid").arg( quotedValue(mSchemaTableName) );
QString oidDeclare = QString("declare oidcursor binary cursor for select regclass(%1)::oid").arg( quotedValue(mSchemaTableName) );
// set up the cursor
PQexecNR(connectionRO, oidDeclare.toUtf8());
QString fetch = "fetch forward 1 from oidcursor";
Expand Down

0 comments on commit 57c508f

Please sign in to comment.