QGIS » QGIS Application

Revert "Revert "Allowing storing GPGK raster layer styles to DB""

This reverts commit 9d8a72256893bd31a51d85927e9abd9cdb5eed29.

Revert "Allowing storing GPGK raster layer styles to DB"

Make convertToProviderType static to bypass thread check

Introduce Qgis::ProviderStyleStorageCapabilities

Postgres provider discover relations: add composite relation test + minor refacto

move some PG connection options from QgsPostgresProvider to QgsPostgresConn

Replace QgsDebugMsg(...) with QgsDebugError(...) and ensure it
is ONLY used for error message reporting

Everything else gets bumped to QgsDebugMsg(..., >= 2)

Mark common postgresql types as non-enumerable upon load

This fixes a big performance issue when loading projects with PostgreSQL layers.
In the last stage of project loading, code in QgisApp would run code
to resolve broken layer dependencies, which in turn tried to find out best...

De-duplicate methods for determining relkind for postgres items

Move postgres relkind enum to Qgis

Avoids having to include qgspostgresprovider header in a bunch
of non-provider related files

[postgres] Do not discard geometry attributes having no SRID

See https://github.com/qgis/QGIS/issues/49380#issuecomment-1282913470

Make SRID/CRS cache a per-connection object, rather than a process-static

Static cache is wrong (same SRID may have different meaning in
different databases) and dangerous (can result in segfaults).

Closes GH-51893

Includes simple testcase for EWKT input/output in...

Fix PG identity default value with long field names

Fix #51563

[Clazy] remove unused-non-trivial-variable

Optionally load all stored styles from DB with correct names.

Fixes #37434

Funded by: Ministère des Forêts, de la Faune et des Parcs - Québec

Fix: PostgreSQL provider force read-only and in recovery

The PR feat: Open layers in a read only mode with Qgis::ProjectReadFlag::ForceReadOnlyLayers #49440 contains an error when checking write capabilities.

The write capabilities has to be checked when the database is not in recovery and when the provider is not forced to be in read-only. The old code checks...

Merge pull request #49960 from rldhont/postgres-uri-param-session-role

feature(postgres): Define session role for connection

feature(postgres): Define session role for connection

Be able to define a session role for postgres connection.

Documentation: https://www.postgresql.org/docs/current/sql-set-role.html

The `session_role` setting will be used to set the current user identifier...

Layer metadata provider API

Implementation of QEP #250 DB metadata storage.

- General API for registering layer metadata providers
- Metadata provider GPKG
- Metadata provider POSTGRES
- Metadata provider POSTGRES RASTER

Tests and custom python metadata provider implementation....

Check for result

Add icon to QgsProviderMetada

PG: Log prepared statements and exec prepared

I'm still in doubt if/how to log params too, they can be huge or binary.

Not logged for now.

More query logging

wip

Re-use possibly cached postgis_version from pgsql description method

[api] Don't use widgets in QgsProviderMetadata::saveStyle implementations

This is not safe to do -- it causes a crash if the api is used in
a background thread

Fixes #46954
Fixes #46914

[api] Add QgsProviderMetadata method to test whether a style with
a specified ID already exists

[postgres] Don't try to retrieve values from srs query if no results are returned

simplify code

Remove useless check

Reverse select CRS

Introduce VectorLayerType flags

Fix PG error when failing to update geom & constrained field (#45266)

The problem was that throwing an exception the prepared statement
was not deallocated.

Fix #45100