Basic trigger question

From: Travis Bauer <trbauer(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Basic trigger question
Date: 2000-05-03 20:40:41
Message-ID: Pine.GSO.4.21.0005031538320.11501-100000@fiddler.cs.indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

I would like a trigger that does the following:

Whenever a record is updated or inserted into table A, insert a copy of
that record into table B, which is has exactly the same structure as table
A, except for an autoincrementing field which should get the next logical
value whenever a record is entered.

I'm sure this is a basic trigger problem, but I'm having trouble
figuringout the docs.

Thank in advance,

----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vladimir V. Zolotych 2000-05-04 06:43:41 Re: Removing NOT NULL Contraint
Previous Message Todd J. Turner 2000-05-03 17:26:58 Re: database copy and move

Browse pgsql-general by date

  From Date Subject
Next Message Terry Jarrard 2000-05-03 21:01:47 What do you think?
Previous Message Cliff Rowley 2000-05-03 20:40:39 Re: [PHP3] Job openings (FreeBSD/C/php/postgresql)