On Sun, Dec 2, 2018 at 7:38 AM Adrian Klaver wrote:
>
> On 12/1/18 8:51 AM, PegoraroF10 wrote:
> > 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
On 12/1/18 8:51 AM, PegoraroF10 wrote:
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
On 1/12/18 6:51 μ.μ., PegoraroF10 wrote:
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
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,
> "PegoraroF10" == PegoraroF10 writes:
PegoraroF10> I would like to user OID value because we change our
PegoraroF10> primary keys, sometimes, OID doesn´t.
"oid" as a special system column and the WITH OIDS option when creating
tables are being removed in pg12 (having been deprecated for
On 12/1/18 4:22 AM, PegoraroF10 wrote:
I´m trying to use transition tables for auditing purposes.
create trigger MyTableAudit_UPD after update on MyTable referencing old
table as Transition_old new table as Transition_new for each statement
execute procedure AuditTable();
create or replace
yes, mytable has OID column
select oid, ID, Name from MyTable limit 3
oid id name
279515 1104Carol
279516 1106Dalva
279517 11008354Melissa
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
On 12/01/2018 06:22 AM, PegoraroF10 wrote:
I´m trying to use transition tables for auditing purposes.
create trigger MyTableAudit_UPD after update on MyTable referencing old
table as Transition_old new table as Transition_new for each statement
execute procedure AuditTable();
create or replace
I´m trying to use transition tables for auditing purposes.
create trigger MyTableAudit_UPD after update on MyTable referencing old
table as Transition_old new table as Transition_new for each statement
execute procedure AuditTable();
create or replace function AuditTable() returns trigger