Postgres Pro
Downloads
Home   >   mailing lists

syncing a serial across tables - Mailing list pgsql-novice

From Keith Worthington
Subject syncing a serial across tables
Date
Msg-id 20050512174434.M66389@narrowpathinc.com
Whole thread Raw
Responses Re: syncing a serial across tables
List pgsql-novice
Tree view 
Hi All,

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?

Kind Regards,
Keith

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Autocommit in Postgresql
Next
From: Volkan YAZICI
Date:
Subject: Re: syncing a serial across tables