Postgres Pro
Downloads
Home   >   mailing lists

Re: MOVE - Mailing list pgsql-general

From PFC
Subject Re: MOVE
Date
Msg-id opskmaoxiith1vuj@musicbox
Whole thread Raw
In response to Re: MOVE  (Dave Smith <dave.smith@candata.com>)
List pgsql-general
Tree view 
> Use an after inset trigger.

    Well I did the reverse, an after delete trigger on the live table which
inserts the deleted row in the history table, and it works very well.
    Thanks.

pgsql-general by date:

Previous
From: PFC
Date:
Subject: Re: MOVE
Next
From: "Jim C. Nasby"
Date:
Subject: Re: OID Usage