Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 1.4 About the Examples Used in this Guide
Postgres Plus Advanced Server Oracle Compatibility Developer's Guide
1.4 About the Examples Used in this Guide
The examples shown in this guide are illustrated using the PSQL program. The prompt that normally appears when using PSQL is omitted in these examples to provide extra clarity for the point being demonstrated.
Examples and output from examples are shown in fixed-width, blue font on a light blue background.
Also note the following points:
● During installation of Postgres Plus Advanced Server the selection for Oracle compatible configuration and defaults must be chosen in order to reproduce the same results as the examples shown in this guide. A default Oracle compatible configuration can be verified by issuing the following commands in PSQL and obtaining the same results as shown below.
SHOW edb_redwood_date; edb_redwood_date ------------------ on SHOW datestyle; DateStyle -------------- Redwood, DMY SHOW edb_redwood_strings; edb_redwood_strings --------------------- on
● The examples use the sample tables, dept, emp, and jobhist, created and loaded when Postgres Plus Advanced Server is installed. The emp table is installed with triggers that must be disabled in order to reproduce the same results as shown in this guide. Log on to Postgres Plus Advanced Server as the enterprisedb superuser and disable the triggers by issuing the following command.
ALTER TABLE emp DISABLE TRIGGER USER;
The triggers on the emp table can later be re-activated with the following command.
ALTER TABLE emp ENABLE TRIGGER USER;