Skip to content

character varying, no serial defined error #34

@ntrip6

Description

@ntrip6

Just testing the plug-in for the first time and I've run into this error on polygon features where the feature "does not has a serial defined"

2025-09-16T13:24:41 WARNING Traceback (most recent call last):
File "C:\Users/USER/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pgversion\dbtools\dbtools.py", line 134, in run
rows = cursor.execute(sql)
^^^^^^^^^^^^^^^^^^^
psycopg2.errors.RaiseException: Table eastbay_utm10.Bldgs_ARF_vicinity does not has a serial defined
CONTEXT: PL/pgSQL function versions._hasserial(character varying) line 34 at RAISE
SQL statement "select * from versions._hasserial('eastbay_utm10.Bldgs_ARF_vicinity')"
PL/pgSQL function versions.pgvsinit(character varying) line 57 at EXECUTE

         During handling of the above exception, another exception occurred:
         
         Traceback (most recent call last):
          File "C:\Users/USER/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pgversion\pgVersion.py", line 313, in doInit
          result, error = myDb.run(sql)
          ^^^^^^^^^^^^^
          File "C:\Users/USER/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pgversion\dbtools\dbtools.py", line 141, in run
          self._error_message(e)
          File "C:\Users/USER/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pgversion\dbtools\dbtools.py", line 307, in _error_message
          QMessageBox.information(None,'PG: Error', str(e[1]))
          ~^^^
         TypeError: 'RaiseException' object is not subscriptable

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions