Re: Transition Tables doesn´t have OID

Поиск
Список
Период
Сортировка
От PegoraroF10
Тема Re: Transition Tables doesn´t have OID
Дата
Msg-id 1543683104800-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: Transition Tables doesn´t have OID  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: Transition Tables doesn´t have OID
Re: Transition Tables doesn´t have OID
Список pgsql-general
ok
then, help me to find alternatives to it.
As I sad, sometimes whe change our PK, so using OID would be a smart way to
have a join between old and new transition tables and we would like to use
transition tables because each statement is a lot faster than each row for
auditing purposes.

So, whats the alternative ? One trigger for each row just for changing PK
values (will occur few times) and another trigger for each statement to do
the logging ?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Process for populating tables in new database
Следующее
От: Slavcho Trnkovski
Дата:
Сообщение: Re: postgis after pg_upgrade