As noticed in dev list, that part of code has a lack of detailed error message, and community is working on it. In the meanwhile, I can only suggest to:
1) check log panel 2) check server messages 3) use a qgis "with debug" version and setup QGIS_DEBUG var to see more messages probably the point 2 is enough btw from a postgres client, try the same query done by the postgres provider: https://github.com/qgis/QGIS/blob/master/src/providers/postgres/qgspostgresprovider.cpp#L4544 look in the same code for saveStyle method to understand how the table is created. regards Luigi Pirelli ************************************************************************************************** * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com * LinkedIn: https://www.linkedin.com/in/luigipirelli * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli * GitHub: https://github.com/luipir * Mastering QGIS 2nd Edition: * https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition ************************************************************************************************** On 13 January 2017 at 03:23, Tony Bazeley <to...@sa.apana.org.au> wrote: > Hi, > > I'm having some trouble attempting to work with styles in postgresql. > > I can successfully save a style to the database - table layer_styles is > created and populated. > But attempting to load brings up the 'Load Style from database dialog' with > messages "No styles found in database' > > Am using QGIS 2.18.2 with postgresql 9.6 and postgis 2.3 > > Would appreciate any thoughts on how to progress. > > Thanks > Tony > > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user