PostgreSQL Version Property

Official Content
This documentation is valid for:

Tells GeneXus what PostgreSQL version is installed in the Database Server.

Values

8.1 or higher The PostgreSQL version installed in the Server is 8.1 or higher. If this value is selected, Unique indexes are generated. This is the default value for GeneXus X Evolution 1 and higher.
8.0 The PostgreSQL version installed in the Server is 8.0. If this value is selected, Unique indexes are generated. This is the default value for  GeneXus X
7.x The PostgreSQL version installed in the Server is 7.x. Unique indexes are not generated.

How to apply changes

Rebuild all objects

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

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.

Scope

DBMS: PostgreSQL

See Also

SQL server version property
Oracle version property
Informix Version Property
MySQL version property
DB2 UDB Version property