Re: Oracle, MySQL, and PostgreSQL feature comparison - Part 2

Поиск
Список
Период
Сортировка
От Jonah H. Harris
Тема Re: Oracle, MySQL, and PostgreSQL feature comparison - Part 2
Дата
Msg-id 36e682920710111153y74215a1hcf1a280863c019a8@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Oracle, MySQL, and PostgreSQL feature comparison - Part 2  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: Oracle, MySQL, and PostgreSQL feature comparison - Part 2  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-advocacy
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/

В списке pgsql-advocacy по дате отправления:

Предыдущее
От: Christian Voelker
Дата:
Сообщение: Re: Oracle, MySQL, and PostgreSQL feature comparison - Part 2
Следующее
От: Chris Travers
Дата:
Сообщение: Re: Oracle, MySQL, and PostgreSQL feature comparison - Part 2