Tracking DDL and DML changes in Postgresql and different versions ofdatabase (advance)

Поиск
Список
Период
Сортировка
От Łukasz Jarych
Тема Tracking DDL and DML changes in Postgresql and different versions ofdatabase (advance)
Дата
Msg-id CAGv31oeocf2dF5h394YAxG_OC2uen5pt-K=zWeuW2UBQTD=fmg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Tracking DDL and DML changes in Postgresql and different versionsof database (advance)  (Pavan Teja <pavan.postgresdba@gmail.com>)
Список pgsql-general
Hi Guys,

i am using Access FE and Postgresql BE.
To track DML changes i have history log table wotking like here:


It is ok but this doesnt solve the problem with trakich DDL changes. 

For DDL changes i can use flyway system but how to combine this with my DML trackinh system? 

Do you have any solutions for this? 

My boss wants to have possibility to save the current version (state) of database with DML and DDL changes. And to easily revert and go back to previous version (rollback all changes).

I do not think so that postgresql has triggers on DDL changes and - this is the most optimal solution? 

Best Wishes,
Luke 

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: existence of a savepoint?
Следующее
От: Pavan Teja
Дата:
Сообщение: Re: Tracking DDL and DML changes in Postgresql and different versionsof database (advance)