Re: Data change logs

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: nolan(at)gw(dot)tssi(dot)com (Mike Nolan)
Cc: blakjak(at)blakjak(dot)sytes(dot)net (Brendan Jurd), pgsql-general(at)postgresql(dot)org (PostgreSQL-general)
Subject: Re: Data change logs
Date: 2004-05-21 06:14:25
Message-ID: 200405210614.i4L6EQ6u023917@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> insert into xxxx_log select * from xxxx where keyfield = NEW.keyfield;

Oops, that should be OLD.keyfield.
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message anony 2004-05-21 06:49:33 Re: Porting SQL Server 2000 database to PostgreSQL
Previous Message Tom Lane 2004-05-21 06:11:37 Re: pg_temp_N temp schema buildup