Re: syncing a serial across tables

Hi,

On 5/12/05, Keith Worthington <keithw@narrowpathinc.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.