Re: Transition Tables doesn´t have OID - Mailing list pgsql-general

From PegoraroF10
Subject Re: Transition Tables doesn´t have OID
Date
Msg-id 1543683104800-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Transition Tables doesn´t have OID  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: Transition Tables doesn´t have OID  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: Transition Tables doesn´t have OID  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Process for populating tables in new database
Next
From: Slavcho Trnkovski
Date:
Subject: Re: postgis after pg_upgrade