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.