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
----------------------------------------------------------------
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 |
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) |