Re: [QGIS-Developer] Time for db manager to become an "opt-in" plugin?

2022-07-10 Thread José de Paula Rodrigues via QGIS-Developer
Hi, all, I must say I agree with Alexandre; one of the most precious feature of QGIS for me and the folks that work with me is the ability to very quickly and easily interact with PostGIS, making experiments, testing a query, adjusting, tailoring, comparing with other kinds of data sets, right the

Re: [QGIS-Developer] QGIS Roadmap

2020-12-11 Thread José de Paula Rodrigues
Does QGIS read e-mail already? So, not feature complete yet 😁 On Fri, Dec 11, 2020 at 6:37 AM Raymond Nijssen wrote: > Time to change the license! $$$ > > (And btw, now I really hope 3.18 will be called 's-Hertogenbosch!!!) > > On 11-12-

[QGIS-Developer] Tests failing with PostgreSQL 12

2020-09-30 Thread José de Paula Rodrigues
Hi folks, Have any of you run tests against PostgreSQL 12/PostGIS 3.0.x lately? They have been failing on me, on my local system, more specifically the one called PyQgsPostgresProvider . I've sent the logs earlier to this list, but it didn't come through, perhaps due to message size. -- ... et

Re: [QGIS-Developer] db manager SQL console very slow

2020-07-09 Thread José de Paula Rodrigues
Perhaps you have some schemas with many (thousands) tables? I've seen this slowness when connecting to a database in which one of the schemas had 4+ tables, and another database with a partitioned table with 7000+ partitions. I've also seen the slowness on the object browser, when first connect

Re: [QGIS-Developer] Build error

2020-07-09 Thread José de Paula Rodrigues
I got this error when trying to build QGIS 3.10.6 against the 5.15 version of the Qt libs/toolchain on Gentoo, and like Debian Sid, it also has sip version 4.19.23. On Thu, Jul 9, 2020 at 12:01 PM Richard Duivenvoorde wrote: > > On 7/9/20 4:49 PM, Paolo Cavallini wrote: > > Hi all, > > make on cu

[QGIS-Developer] Globe Plugin

2020-05-19 Thread José de Paula Rodrigues
Hi all, I've taken a shot at building qgis with the globe plugin enabled on a current Gentoo. I've found that the plugin must be built against osgearth no newer than version 2.8 (which was released 2016-09-15), because newer versions remove features needed by Globe (osgearth 2.9, released 2018-02-

[QGIS-Developer] Request for comments: saving features with GENERATED columns on PostgreSQL 12+

2020-05-04 Thread José de Paula Rodrigues
Hello all, I've just submitted a PR (https://github.com/qgis/QGIS/pull/35995) that allows QGIS to manipulate features from PostgreSQL tables with GENERATED columns. Those are a new feature introduced by PostgreSQL 12 ( https://www.postgresql.org/docs/12/ddl-generated-columns.html ), useful for com

[QGIS-Developer] Trivial fix on DB Manager (PostgreSQL)

2020-04-25 Thread José de Paula Rodrigues
Hi all, I've opened a new issue regarding CONSTRAINT TRIGGERs on DB Manager ( https://github.com/qgis/QGIS/issues/35967) - in which tables with such a trigger error out when trying to display their properties -, along with a trivial, one-line PR (https://github.com/qgis/QGIS/pull/35983). Could a c

[QGIS-Developer] Help with PR 34780 (don't cast PostgreSQL bigint PKs to text)

2020-02-28 Thread José de Paula Rodrigues
Hi all, I'm trying to prevent QGIS from casting bigint/bigserial primary keys to text. I've submitted a pull request ( https://github.com/qgis/QGIS/pull/34780 ); it builds and runs correctly on my system (PostgreSQL 12.2, Gentoo Linux), but the unit tests fail both on my system and on Travis (whic