Servoy 3.5.x and PostgreSQL 8.3.x

Classic Servoy
1

Hi all,

We are having some issues with custom SQL queries when upgrading to the above combination. It seems either

a) Servoy is not feeding PostgreSQL the parameters of the correct data type for the queries

or

b) PostgreSQL has become more strict when checking parameters in version 8.3.

We get ‘Operator does not exists…’ type errors.

All problems so far can be fixed easily by type-casting the parameters in the SQL query, such as the modified_date in the example below

SELECT x FROM some_table WHERE modified_date =?::timestamp

Have anybody else seen this problem?

Anyway, PostgreSQL 8.3 is quite a bit faster than 8.1 or 8.2.

2

Yes, seen it: Postgress has become more strict.

Make sure you pass the right type of variable as parameter into the prepared statement.

Paul