Re: How would I make a table of autonumbers/sequences? - Mailing list pgsql-hackers

On 17 Aug 2001 06:58:38 -0700, Joseph Castille <joseph.castille@wcom.com> wrote:
> I want to make a field in a table contain numbers that increment each
> time a record is updated.  How would I go about doing this?
> 
> 
> Example:
> 
> Table1
> CustID     balance   
> A12        255.32
> B20        132.20
> 
> Table2
> CustID     transactions   
> A12        7
> B20        33
> 
> 
> Every time something is inserted or updated in table1 I want to
> increment that customer's number of transactions in table2.  How would
> I go about doing this?
> 


This sounds like a good place for a trigger.

Did you ask this on the pgsql-general list yet?
You will probably have better luck there.