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
[QGIS-Developer] bug or feature? layer_styles table created not in the public schema
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