On 10/11/07, Jeff Davis <pgsql@j-davis.com> wrote:
> Postgresql too has this functionality and it seems to be as flexible and
> configurable as Oracle's.
Not exactly. Oracle auditing uses autonomous transactions and
actually logs attempts to change data as well as changes themselves
whereas Postgres would only log to a table on commit. In Postgres,
you have to specifically write a trigger which simulates an autonomous
transaction using dblink.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/