Configuration Parameters Compatible with Oracle Databases v12

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 edb_redwood_date.
  • 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 edb_redwood_raw_names.
  • 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 edb_redwood_strings.
  • 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 edb_stmt_level_tx.
  • oracle_home – Point Advanced Server to the correct Oracle installation directory. See oracle_home.

edb_redwood_date edb_redwood_raw_names edb_redwood_strings edb_stmt_level_tx oracle_home