We see entries in the Server log like
org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "HTTEMP1482141051962108"
It seems that a SQL statement that Servoy generated with some temporary tables can not be processed by postgres.
The first part of such a SQL statement looks like this:
select project_elements.project_element_id from project_elements project_elements
inner join projects projects on project_elements.project_id=projects.project_id and (projects.tenant_id = ? or projects.tenant_id is null) and (projects.is_deleted = ? or projects.is_deleted is null)
and "HTTEMP1482141051962108".svy_check__1482141052 is not null
left outer join HT_TEMP_1482141051 "HTTEMP1482141051962108" on projects.project_id="HTTEMP1482141051962108".project_id_1482141053
where ...
Due to which reason does Servoy insert those temporary tables, and is it possible to avoid that behaviour, so that postgres does not fail?