Re: [QGIS-Developer] bug or feature? layer_styles table created not in the public schema
+1 Cheers On 6 September 2020 19:18:26 CEST, "Régis Haubourg" wrote: >Hi, >I'm my opinion, we should add a dialog to let the user choose the >destination schema. Public schema should really be left untouched by >default. >Cheers >Regis > >Le dim. 6 sept. 2020 à 18:26, Giovanni Manghi > a >écrit : > >> Hi all, >> >> On Sat, Sep 5, 2020 at 11:05 PM Paolo Cavallini > >> wrote: >> > >> > This follows the search_path setting. >> >> oh I see. Anyway this case seems possible (even if uncommon), and >when >> it happens it leads a user to being cut off from accessing styles >> stored in public. >> So my question stands, should this be considered a bug (considered >> that the QGIS does not allows to choose the schema where to look for >> styles)? >> >> -- G -- >> ___ >> QGIS-Developer mailing list >> QGIS-Developer@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer -- Please excuse my brevity.___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] bug or feature? layer_styles table created not in the public schema
Hi, I'm my opinion, we should add a dialog to let the user choose the destination schema. Public schema should really be left untouched by default. Cheers Regis Le dim. 6 sept. 2020 à 18:26, Giovanni Manghi a écrit : > Hi all, > > On Sat, Sep 5, 2020 at 11:05 PM Paolo Cavallini > wrote: > > > > This follows the search_path setting. > > oh I see. Anyway this case seems possible (even if uncommon), and when > it happens it leads a user to being cut off from accessing styles > stored in public. > So my question stands, should this be considered a bug (considered > that the QGIS does not allows to choose the schema where to look for > styles)? > > -- G -- > ___ > QGIS-Developer mailing list > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] bug or feature? layer_styles table created not in the public schema
Hi all, On Sat, Sep 5, 2020 at 11:05 PM Paolo Cavallini wrote: > > This follows the search_path setting. oh I see. Anyway this case seems possible (even if uncommon), and when it happens it leads a user to being cut off from accessing styles stored in public. So my question stands, should this be considered a bug (considered that the QGIS does not allows to choose the schema where to look for styles)? -- G -- ___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [QGIS-Developer] bug or feature? layer_styles table created not in the public schema
This follows the search_path setting. Cheers. On 5 September 2020 23:38:03 CEST, Giovanni Manghi wrote: >Hi all, >by chance I noticed the following: > >If in a PostgreSQL DB exists a schema that has the same name as a user >that has full permissions on that schema, then if the user saves a >style to the DB this is saved in a "layer_styles" table in this >schema, not public. > >Moreover if the user tries to load a style from the DB it only sees >the styles in this "secondary" layer_styles table, not the one in >public. > >Feature or bug? > >Seems strange it is by chance, anyway if it is implemented so by >design I think that in the "load style from DB" menu is missing the >option to choose in what schema look for, like the similar menu for >loading projects from DB. > >Opinions? > >cheers > >-- G -- >___ >QGIS-Developer mailing list >QGIS-Developer@lists.osgeo.org >List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer -- Please excuse my brevity.___ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer