1.3 Configuration Parameters Compatible with Oracle Databases

Table of Contents Previous Next


1 Introduction : 1.3 Configuration Parameters Compatible with Oracle Databases

EDB Postgres Advanced Server supports the development and execution of applications compatible with PostgreSQL and Oracle. Some system behaviors can be altered to act in a more PostgreSQL or in a more Oracle compliant manner; these behaviors are controlled by configuration parameters. Modifying the parameters in the postgresql.conf file changes the behavior for all databases in the cluster, while a user or group can SET the parameter value on the command line, effecting only their session. These parameters are:
edb_redwood_date – Controls whether or not a time component is stored in DATE columns. For behavior compatible with Oracle databases, set edb_redwood_date to TRUE. See Section 1.3.1.
edb_redwood_raw_names – Controls whether database object names appear in uppercase or lowercase letters when viewed from Oracle system catalogs. For behavior compatible with Oracle databases, edb_redwood_raw_names is set to its default value of FALSE. To view database object names as they are actually stored in the PostgreSQL system catalogs, set edb_redwood_raw_names to TRUE. See Section 1.3.2.
edb_redwood_strings – Equates null to an empty string for purposes of string concatenation operations. For behavior compatible with Oracle databases, set edb_redwood_strings to true. See Section 1.3.3.
edb_stmt_level_tx – Isolates automatic rollback of an aborted SQL command to statement level rollback only – the entire, current transaction is not automatically rolled back as is the case for default PostgreSQL behavior. For behavior compatible with Oracle databases, set edb_stmt_level_tx to true; however, use only when absolutely necessary. See Section 1.3.4.
oracle_home – Point Advanced Server to the correct Oracle installation directory. See Section 1.3.5.

1 Introduction : 1.3 Configuration Parameters Compatible with Oracle Databases

Table of Contents Previous Next