Impossible de charger les tables sous postgresql avec pg_service

[DelazJ]

Description du bug

J'utilise pg_service pour me connecter à ma base (Postgresql 14, postgis 3.2).
Quand je lance l'import des données edigeo, tout semble bien se passer: le processus va jusqu'à la finalisation, j'ai des tables qui sont créées dans le schéma, mais... les entités spatiales ne sont pas là. toutes les couches du style geo_... sont VIDES.

En utilisant une connexion avec les identifiants et mdp stockées lisibles, ça passe crème. Tout est bon.

Reproduire le bug

1. Configurer une connexion à une base PostgreSQL en utilisant un fichier de service (pas d'utilisation du système d'authentification de QGIS)
2. Lancer l'import de l'edigeo dans la base
3. Ca devrait "bien" se passer la première fois, mais avec des tables géométriques vides
4. Relancer à nouveau l'import et vous aurez des messages d'erreur

Log

Erreur SQL : SET search_path = "cadastre_2023", public, pg_catalog; UPDATE subdsect_id SET geom = ST_Transform(ST_GeomFromText('MULTIPOLYGON(((475831.25 6693890.38,475830.54 6693888.44,475827.0 6693879.33,475816.98 6693851.52,475779.38 6693747.55,475778.01 6693743.79,475802.53 6693743.46,475823.4 6693742.66,475835.3 6693739.39,475858.25 6693732.27,475855.01 6693725.26,475853.28 6693720.09,475856.84 6693717.2,475858.35 6693716.69,475939.15 6693683.89,475947.53 6693680.48,475966.79 6693666.01,475984.74 6693697.94,475999.45 6693724.11,476001.92 6693722.91,476018.34 6693745.76,476024.19 6693753.89,476040.64 6693780.06,476054.52 6693802.08,476068.93 6693825.1,476079.69 6693841.8,476080.03 6693842.31,476081.27 6693845.46,476016.2 6693865.01,475936.05 6693882.97,475914.42 6693888.27,475840.64 6693914.22,475838.96 6693910.02,475834.26 6693898.38,475831.25 6693890.38)), ((475743.16 6693505.44,475750.91 6693528.2,475759.11 6693552.29,475765.18 6693570.14,475764.03 6693570.63,475759.05 6693572.77,475742.03 6693580.09,475739.72 6693583.0,475742.51 6693594.45,475749.49 6693619.4,475749.85 6693645.48,475746.94 6693647.04,475745.94 6693647.57,475711.1 6693663.95,475707.9 6693665.45,475702.66 6693667.91,475692.61 6693671.36,475672.93 6693678.1,475643.0 6693609.59,475640.5 6693603.96,475631.99 6693606.57,475590.33 6693620.02,475572.61 6693625.48,475554.31 6693548.08,475578.26 6693538.99,475601.04 6693529.4,475615.84 6693523.17,475638.36 6693514.49,475621.41 6693458.4,475609.51 6693445.19,475608.3 6693442.85,475605.1 6693436.66,475600.65 6693418.48,475586.18 6693359.54,475571.94 6693301.54,475561.43 6693300.03,475560.87 6693296.85,475554.56 6693297.68,475546.41 6693239.68,475582.62 6693234.55,475605.79 6693232.73,475610.11 6693232.0,475617.59 6693283.07,475622.16 6693282.48,475672.16 6693274.86,475678.93 6693313.61,475679.59 6693317.43,475680.07 6693320.16,475680.39 6693322.0,475714.78 6693320.08,475742.87 6693398.12,475708.75 6693411.56,475712.06 6693419.97,475716.13 6693430.22,475722.51 6693447.8,475735.16 6693482.95,475743.16 6693505.44)), ((474615.33 6693953.13,474581.03 6693971.0,474529.26 6693987.24,474528.21 6693974.25,474529.21 6693934.92,474533.94 6693895.71,474540.28 6693857.16,474516.29 6693716.16,474504.71 6693651.03,474500.74 6693638.95,474493.75 6693596.45,474494.32 6693591.28,474471.21 6693453.5,474443.74 6693297.41,474457.58 6693298.31,474640.74 6693297.45,474655.15 6693297.92,474759.72 6693304.92,474819.86 6693309.01,474830.33 6693311.33,474802.45 6693443.43,474831.02 6693730.93,474826.5 6693745.42,474800.03 6693888.57,474640.72 6693942.82,474615.33 6693953.13)))', 2154), 2154) WHERE object_rid = 'Objet_1302440'  AND geom @ ST_Transform(ST_GeomFromText('MULTIPOLYGON(((475831.25 6693890.38,475830.54 6693888.44,475827.0 6693879.33,475816.98 6693851.52,475779.38 6693747.55,475778.01 6693743.79,475802.53 6693743.46,475823.4 6693742.66,475835.3 6693739.39,475858.25 6693732.27,475855.01 6693725.26,475853.28 6693720.09,475856.84 6693717.2,475858.35 6693716.69,475939.15 6693683.89,475947.53 6693680.48,475966.79 6693666.01,475984.74 6693697.94,475999.45 6693724.11,476001.92 6693722.91,476018.34 6693745.76,476024.19 6693753.89,476040.64 6693780.06,476054.52 6693802.08,476068.93 6693825.1,476079.69 6693841.8,476080.03 6693842.31,476081.27 6693845.46,476016.2 6693865.01,475936.05 6693882.97,475914.42 6693888.27,475840.64 6693914.22,475838.96 6693910.02,475834.26 6693898.38,475831.25 6693890.38)), ((475743.16 6693505.44,475750.91 6693528.2,475759.11 6693552.29,475765.18 6693570.14,475764.03 6693570.63,475759.05 6693572.77,475742.03 6693580.09,475739.72 6693583.0,475742.51 6693594.45,475749.49 6693619.4,475749.85 6693645.48,475746.94 6693647.04,475745.94 6693647.57,475711.1 6693663.95,475707.9 6693665.45,475702.66 6693667.91,475692.61 6693671.36,475672.93 6693678.1,475643.0 6693609.59,475640.5 6693603.96,475631.99 6693606.57,475590.33 6693620.02,475572.61 6693625.48,475554.31 6693548.08,475578.26 6693538.99,475601.04 6693529.4,475615.84 6693523.17,475638.36 6693514.49,475621.41 6693458.4,475609.51 6693445.19,475608.3 6693442.85,475605.1 6693436.66,475600.65 6693418.48,475586.18 6693359.54,475571.94 6693301.54,475561.43 6693300.03,475560.87 6693296.85,475554.56 6693297.68,475546.41 6693239.68,475582.62 6693234.55,475605.79 6693232.73,475610.11 6693232.0,475617.59 6693283.07,475622.16 6693282.48,475672.16 6693274.86,475678.93 6693313.61,475679.59 6693317.43,475680.07 6693320.16,475680.39 6693322.0,475714.78 6693320.08,475742.87 6693398.12,475708.75 6693411.56,475712.06 6693419.97,475716.13 6693430.22,475722.51 6693447.8,475735.16 6693482.95,475743.16 6693505.44)), ((474615.33 6693953.13,474581.03 6693971.0,474529.26 6693987.24,474528.21 6693974.25,474529.21 6693934.92,474533.94 6693895.71,474540.28 6693857.16,474516.29 6693716.16,474504.71 6693651.03,474500.74 6693638.95,474493.75 6693596.45,474494.32 6693591.28,474471.21 6693453.5,474443.74 6693297.41,474457.58 6693298.31,474640.74 6693297.45,474655.15 6693297.92,474759.72 6693304.92,474819.86 6693309.01,474830.33 6693311.33,474802.45 6693443.43,474831.02 6693730.93,474826.5 6693745.42,474800.03 6693888.57,474640.72 6693942.82,474615.33 6693953.13)))', 2154), 2154) ;  renvoyé 0 [ERREUR:  la relation « subdsect_id » n'existe pas
LINE 1: ..._path = "cadastre_2023", public, pg_catalog; UPDATE subdsect_i...

Environnement

• OS: Windows
• Version de QGIS : 3.30
• Version du plugin : 1.17.3