Re: history table - Mailing list pgsql-general

From Robin Helgelin
Subject Re: history table
Date
Msg-id c014a9590708212235w18816f5bq5cd8ac99704d2e33@mail.gmail.com
Whole thread Raw
In response to Re: history table  (Guy Rouillier <guyr-ml1@burntmail.com>)
List pgsql-general
On 8/21/07, Guy Rouillier <guyr-ml1@burntmail.com> wrote:
> Well, I can't find a way to set a variable associated with a connection,
> so probably the easiest thing to do is to add an "updated_by" column to
> your regular table (i.e., the non-history version.)  Then just include
> the userid from your webapp as the value for that column.  Your history
> table can then be updated by just copying the entire row from the base
> table whenever an insert or update occurs.

Yes, I think this will be the easiest way, thanks!

--
        regards,
        Robin

pgsql-general by date:

Previous
From: Trinath Somanchi
Date:
Subject: Pgcluster 1.7 Fail safe !!!
Next
From: Tom Lane
Date:
Subject: Re: Converting non-null unique idx to pkey