<div dir="ltr"><div><div>Hi,</div><div><br></div><div>@ Tom : I really would like to trust QGIS method instead of managing manually different providers.<br></div><div><br></div><div>@ Luigi<br></div>No error message, even worse : i got a message telling everything went well ;)</div><div><br></div><div>layer.saveDefaultStyle()<br>(u'The style dbname=\'qgis\' host=localhost port=5432 user=\'mdouchin\' sslmode=disable key=\'ogc_fid\' estimatedmetadata=true srid=2154 type=MultiPolygon table="sup"."geo_commune" (geom) sql= was updated in the database.', True)</div><div><br></div><div>But the line is not created in the layer_styles table.</div><div><br></div><div>Michaël<br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-09-25 14:48 GMT+02:00 Luigi Pirelli <span dir="ltr"><<a href="mailto:luipir@gmail.com" target="_blank">luipir@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">from the code:<br>
<br>
mLayer->saveStyleToDatabase and mLayer->saveDefaultStyle<br>
<br>
and in<br>
QString QgsMapLayer::saveDefaultStyle( bool & theResultFlag )<br>
{<br>
  return saveNamedStyle( styleURI(), theResultFlag );<br>
}<br>
<br>
=> seems you are doing correct.<br>
<br>
any log message?<br>
<br>
******************************<wbr>************<br>
<br>
<br>
void QgsVectorLayerProperties::<wbr>saveDefaultStyle_clicked()<br>
{<br>
  apply();<br>
  QString errorMsg;<br>
  if ( mLayer->dataProvider()-><wbr>isSaveAndLoadStyleToDBSupporte<wbr>d() )<br>
  {<br>
    QMessageBox askToUser;<br>
    askToUser.setText( tr( "Save default style to: " ) );<br>
    askToUser.setIcon( QMessageBox::Question );<br>
    askToUser.addButton( tr( "Cancel" ), QMessageBox::RejectRole );<br>
    askToUser.addButton( tr( "Local database" ), QMessageBox::NoRole );<br>
    askToUser.addButton( tr( "Datasource database" ), QMessageBox::YesRole );<br>
<br>
    switch ( askToUser.exec() )<br>
    {<br>
      case 0:<br>
        return;<br>
      case 2:<br>
        mLayer->saveStyleToDatabase( "", "", true, "", errorMsg );<br>
        if ( errorMsg.isNull() )<br>
        {<br>
          return;<br>
        }<br>
        break;<br>
      default:<br>
        break;<br>
    }<br>
  }<br>
<br>
  bool defaultSavedFlag = false;<br>
  errorMsg = mLayer->saveDefaultStyle( defaultSavedFlag );<br>
  if ( !defaultSavedFlag )<br>
  {<br>
    QMessageBox::warning( this, tr( "Default Style" ), errorMsg );<br>
  }<br>
}<br>
Luigi Pirelli<br>
<br>
******************************<wbr>******************************<wbr>******************************<wbr>********<br>
* Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com<br>
* LinkedIn: <a href="https://www.linkedin.com/in/luigipirelli" rel="noreferrer" target="_blank">https://www.linkedin.com/in/<wbr>luigipirelli</a><br>
* Stackexchange: <a href="http://gis.stackexchange.com/users/19667/luigi-pirelli" rel="noreferrer" target="_blank">http://gis.stackexchange.com/<wbr>users/19667/luigi-pirelli</a><br>
* GitHub: <a href="https://github.com/luipir" rel="noreferrer" target="_blank">https://github.com/luipir</a><br>
* Mastering QGIS 2nd Edition:<br>
* <a href="https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition" rel="noreferrer" target="_blank">https://www.packtpub.com/big-<wbr>data-and-business-<wbr>intelligence/mastering-qgis-<wbr>second-edition</a><br>
******************************<wbr>******************************<wbr>******************************<wbr>********<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
On 25 September 2017 at 13:44, Tom Chadwin <<a href="mailto:tom.chadwin@nnpa.org.uk">tom.chadwin@nnpa.org.uk</a>> wrote:<br>
> Perhaps you have to do it manually via a PostGIS query matching<br>
> f_table_catalog, f_table_schema, and f_table_name, and updating styleqml and<br>
> stylesld?<br>
><br>
> Tom<br>
><br>
><br>
><br>
> -----<br>
> Buy Pie Spy: Adventures in British pastry 2010-11 on Amazon<br>
> --<br>
> Sent from: <a href="http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-f4099106.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.<wbr>nabble.com/QGIS-Developer-<wbr>f4099106.html</a><br>
> ______________________________<wbr>_________________<br>
> QGIS-Developer mailing list<br>
> <a href="mailto:QGIS-Developer@lists.osgeo.org">QGIS-Developer@lists.osgeo.org</a><br>
> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a><br>
> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-<wbr>developer</a><br>
</div></div></blockquote></div><br></div>