Hi,
On 5/12/05, Keith Worthington <keithw(at)narrowpathinc(dot)com> wrote:
> I believe I need to use a serial column in two tables and keep then synched.
> I am thinking that I could use an AFTER INSERT trigger and INSERT currval()
> into the second table to keep them synched. Has anyone done this before? Is
> this a bad idea?
If both columns in both table will have the same value, why don't you
just reference one to another? This will keep synchorization
automaticly.
Regards.