| 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: | Whole Thread | Raw Message | 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) |