Hello,

i want to use PostgrSQL views from QSqlTableModel. Here this does not work. The 
error 
QSqlTableModel.lastError.text () displays:
  Unable to find table <view name>.

Checking
  QSqlDatabase::tables ()

only return the tables but not the views defined in the database. Is that a 
limnitaion/bug ?

As result neither QSqlTableModel, QSqlQueryModel and QSqlQuery are able to 
access the 
views.

Using the psql command line interface (same credentials) works. Tested with sql 
query:
  select * from <view name>;

Environment:

OS: Gentoo Linux (stable)
Linux Kernel 4.9.16
PostgreSQL 9.5.7
Qt 5.6.2
gcc 5.4.0


Any hints ?

kind regards
  Petric Frank

_______________________________________________
Interest mailing list
Interest@qt-project.org
http://lists.qt-project.org/mailman/listinfo/interest

Reply via email to