PostgreSQL DATETIME type mapping change

Before Genero 3.00, the PostgreSQL driver converted DATETIME types as follows:

• DATETIME HOUR TO MINUTE was converted to TIMESTAMP(3) WITHOUT TIME ZONE
• DATETIME HOUR TO SECOND was converted to TIME(0) WITHOUT TIME ZONE
• DATETIME HOUR TO FRACTION(n) was converted to TIME(n+1) WITHOUT TIME ZONE
• DATETIME YEAR TO MINUTE was converted to TIMESTAMP(3) WITHOUT TIME ZONE
• DATETIME YEAR TO SECOND was converted to TIMESTAMP(3) WITHOUT TIME ZONE
• DATETIME YEAR TO FRACTION(n) was converted to TIMESTAMP(n+1) WITHOUT TIME ZONE

Starting with Genero 3.00, when creating a table in a BDL program with CREATE TABLE, the types are converted in a different way:

This bug fix introduces an incompatibility and can have an impact on applications using DATETIME HOUR TO MINUTE, DATETIME HOUR TO FRACTION(n) or DATETIME YEAR TO FRACTION(n). If you are using one of these types, consider reviewing your database schema, to modify the column types according to the new SQL type conversion rules.