PostgreSQL version property

Official Content
This documentation is valid for:
Sets the PostgreSQL version that is installed in the Database Server.

Values

7.x The PostgreSQL version installed in the Server is 7.x. Unique indexes are not generated.
8.0 The PostgreSQL version installed in the Server is 8.0. If this value is selected, Unique indexes are generated.
8.1 or 8.2 The PostgreSQL version installed in the Server is 8.1 or 8.2. If this value is selected, Unique indexes are generated.
8.3 or higher The PostgreSQL version installed in the Server is 8.3 or higher. If this value is selected, Unique indexes are generated.

Scope

Available at the Data Store.
Data Store: POSTGRESQL

Description

It is used, for example, to determine the syntax for OUTER JOINs and for table creation/reorganization (i.e. syntax of CREATE TABLE, CREATE INDEX, etc.).

Every new version of the DBMS has new features that are used by GeneXus, which generates different SQL sentences or considers properties that can be applied to the new version.

Note: Unique indexes are not supported in PostgreSQL for versions prior to 7.3.11 (this is a restriction of the database engine itself).

How to apply changes

To apply the corresponding changes when the property value is configured, execute a Rebuild All.