Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-79332

QSqlTableModel.setTable() fails with PostgreSQL 12

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Not Evaluated Not Evaluated
    • 5.14
    • 5.13.1
    • SQL Support
    • None
    • ArchLinux, PyQt5 5.13.1
    • Linux/X11

      I don't know if this is a duplicate of QTBUG-79033 or not, but setTable() comes first:

      model = QtSql.QSqlTableModel()
      db = model.database()
      logging.debug("Data base tables: %s", db.tables()) # <-- correct answer
      model.setTable("****") # <-- name is contained in the list from db.tables()
      logging.debug("Message by model.setTable: %s",
                    model.lastError().text()) # <-- error, see below

      Result of running this:

      DEBUG:root:Data base tables: ['t_manip', 't_spiel', 't_stamm', 't_ewtab', 't_pps', 't_tab']
      DEBUG:root:Message by model.setTable: Unable to find table t_ewtab

      This is Python with PyQt5, not C++ with Qt, but I don't think that makes a difference.

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            mabrand Mark Brand
            skoczian Sibylle Koczian
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes