As was stated in the introduction, Postgres Plus Advanced Server supports the development and execution of PostgreSQL and Oracle applications. There are a number of system behaviors that can be altered to act in a more PostgreSQL or in a more Oracle compliant manner. These are controlled by configuration parameters that can be found in the postgresql.conf file in the database cluster data directory. Changing the parameters in the postgresql.conf file changes the behavior over all databases in the cluster. More fine-grained adjustment of these parameters can be done by database, by user or group, or by session. These parameters are the following:
● edb_redwood_date – Controls whether or not a time component is stored in DATE columns. For Oracle compatible behavior, set edb_redwood_date to “true”.
● edb_redwood_strings – Equates null to an empty string for purposes of string concatenation operations. For Oracle compatible behavior, set edb_redwood_strings to “true”.
● 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 Oracle compatible behavior, set edb_stmt_level_tx to “true”; however, use only when absolutely necessary. See Section 1.3.3.
● oracle_home – Point Postgres Plus Advanced Server to the correct Oracle installation directory. See Section 1.3.4.
