[postgres] Don't try to retrieve values from srs query if no results …

…are returned
qgis · Dec 10, 2021 · 8bf2902 · 8bf2902
1 parent 3f00597
commit 8bf2902
Showing 1 changed file with 15 additions and 12 deletions.
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -433,20 +433,23 @@ QgsCoordinateReferenceSystem QgsPostgresProvider::sridToCrs( int srid, QgsPostgr
       QgsPostgresResult result( conn->PQexec( QStringLiteral( "SELECT auth_name, auth_srid, srtext, proj4text FROM spatial_ref_sys WHERE srid=%1" ).arg( srid ) ) );
       if ( result.PQresultStatus() == PGRES_TUPLES_OK )
       {
-        const QString authName = result.PQgetvalue( 0, 0 );
-        const QString authSRID = result.PQgetvalue( 0, 1 );
-        const QString srText = result.PQgetvalue( 0, 2 );
-        bool ok = false;
-        if ( authName == QLatin1String( "EPSG" ) || authName == QLatin1String( "ESRI" ) )
+        if ( result.PQntuples() > 0 )
         {
-          ok = crs.createFromUserInput( authName + ':' + authSRID );
-        }
-        if ( !ok && !srText.isEmpty() )
-        {
-          ok = crs.createFromUserInput( srText );
+          const QString authName = result.PQgetvalue( 0, 0 );
+          const QString authSRID = result.PQgetvalue( 0, 1 );
+          const QString srText = result.PQgetvalue( 0, 2 );
+          bool ok = false;
+          if ( authName == QLatin1String( "EPSG" ) || authName == QLatin1String( "ESRI" ) )
+          {
+            ok = crs.createFromUserInput( authName + ':' + authSRID );
+          }
+          if ( !ok && !srText.isEmpty() )
+          {
+            ok = crs.createFromUserInput( srText );
+          }
+          if ( !ok )
+            crs = QgsCoordinateReferenceSystem::fromProj( result.PQgetvalue( 0, 3 ) );
         }
-        if ( !ok )
-          crs = QgsCoordinateReferenceSystem::fromProj( result.PQgetvalue( 0, 3 ) );
         sCrsCache.insert( srid, crs );
       }
     }