Home > mailing lists

Re: Data change logs - Mailing list pgsql-general

From	Mike Nolan
Subject	Re: Data change logs
Date	May 21, 2004 06:15:22
Msg-id	200405210614.i4L6EQ6u023917@gw.tssi.com Whole thread Raw
In response to	Re: Data change logs (Mike Nolan <nolan@gw.tssi.com>)
List	pgsql-general

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

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

From: Tom Lane
Date: 21 May 2004, 06:12:09
Subject: Re: pg_temp_N temp schema buildup

From: Jeff Davis
Date: 21 May 2004, 06:51:07
Subject: Re: Am I locking more than I need to?