PostgreSQL

We have tested the ITP/MDK Repository with PostgreSQL 8.2.11. In order to work properly with ITP/MDK Repository, the PostgreSQL database needs some installation options and configuration settings to be correctly set:

• PostgreSQL should not be installed with the default "C" collation. Refer to note below for more information.
• The PostgreSQL database used by ITP/MDK Repository must be created with encoding UTF8.
• After creation of the empty database the script written in the file ..\<PostgreSQL installed folder>\share\contrib\lo.sql must be executed. This file is distributed with the PostgreSQL installation. The script allows maintenance of large objects in the database.
• Choose the PostgreSQL Unicode driver as ODBC connection.
• Set the level 'rollback on errors' to Statement on the ODBC Data source. To do this, open the configuration of the Data Source in the ODBC Data Source Administrator, click Datasource under Options, select Page 2, and select Statement under Level of rollback on errors.

Note

If PostgreSQL is installed with the default "C" collation, it is still possible to use the ITP/MDK Repository with it. However, handling of characters with diacritics will not be correct. For instance, upper- and lowercase variants of the same character with a diacritic are treated as distinct characters, so searching on these will always be case sensitive. We advise using a properly installed and configured PostgreSQL database.