Re: syncing a serial across tables

On Thu, May 12, 2005 at 21:02:31 +0300,
  Volkan YAZICI <volkan.yazici@gmail.com> wrote:
> 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.

If they really are supposed to be 1 to 1, then the references will need
to go both ways.