Bonjour,

J'ai une base connectée à une DB PostgreSQL 9.6.
La base comporte des formulaires simples et d'autres composés de nombreux sous-formulaires en cascade (jusqu'à 5 niveaux de sous-formulaires).

Au chargement d'un formulaire comportant au moins un sous-formulaire, de nombreuses erreurs sont générées dans le log de PostgreSQL:
Code sql : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
STATEMENT: SELECT * FROM "public"."logement" WHERE ( 0 = 1 ) AND ( ( ( "public"."logement"."id" = :link_from_id_logement ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 88
STATEMENT: SELECT * FROM "public"."immeuble" WHERE ( 0 = 1 ) AND ( ( ( "public"."immeuble"."id" = :link_from_immeuble ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 82
STATEMENT: SELECT * FROM "public"."ville" WHERE ( 0 = 1 ) AND ( ( ( "public"."ville"."id" = :link_from_adresse_ville ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 94
STATEMENT: SELECT * FROM "public"."code_postal" WHERE ( 0 = 1 ) AND ( ( ( "public"."code_postal"."id" = :link_from_adresse_cp ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 78
STATEMENT: SELECT * FROM "public"."rue" WHERE ( 0 = 1 ) AND ( ( ( "public"."rue"."id" = :link_from_adresse_rue ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 96
STATEMENT: SELECT * FROM "public"."l_zone_rue" WHERE ( 0 = 1 ) AND ( ( ( "public"."l_zone_rue"."id_rue" = :link_from_adresse_rue ) AND ( "public"."l_zone_rue"."numero_rue_de" = :link_from_numero_rue ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 82
STATEMENT: SELECT * FROM "public"."zones" WHERE ( 0 = 1 ) AND ( ( ( "public"."zones"."id" = :link_from_id_zone ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 92
STATEMENT: SELECT * FROM "public"."l_cq_rue" WHERE ( 0 = 1 ) AND ( ( ( "public"."l_cq_rue"."id_rue" = :link_from_adresse_rue ) AND ( "public"."l_cq_rue"."numero_rue_de" = :link_from_numero_rue ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 104
STATEMENT: SELECT * FROM "public"."contrat_quartier" WHERE ( 0 = 1 ) AND ( ( ( "public"."contrat_quartier"."id" = :link_from_id_cq ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 84
STATEMENT: SELECT * FROM "public"."usager" WHERE ( 0 = 1 ) AND ( ( ( "public"."usager"."id" = :link_from_id_proprietaire ) ) AND ( 0 = 1 ) )
ERROR: syntax error at or near ":" at character 84
STATEMENT: SELECT * FROM "public"."usager" WHERE ( 0 = 1 ) AND ( ( ( "public"."usager"."id" = :link_from_id_usager ) ) AND ( 0 = 1 ) )
Le formulaire fonctionne correctement, mais le chargement des données est très lent à cause, me semble-t'il, de ces erreurs.

Quelqu'un aurait une bonne idée ?

Petites précisions:
les connecteurs SDBC et JDBC donnent le même résultat
La version stable 5.2.7.2 donne le même résultat

Libreoffice 5.3.3.1
Mac OS 10.12