Cascade Updating

From: Tom Ansley <tansley(at)law(dot)du(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Cascade Updating
Date: 2003-01-14 17:35:27
Message-ID: 1042565727.12464.3.camel@tom.law.du.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

I have two tables that are linked that have about 300 rows in both that
need to be updated. But, the update needs to cascade from the first to
the second table since the update involves the key.

Anybody have a method for doing this? I just do not feel like having to
delete and add all those lines again.

Thanks

--
Tom Ansley <tansley(at)law(dot)du(dot)edu>
Graduate Tax Program Denver University

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2003-01-14 17:36:08 Re: xml
Previous Message Tom Lane 2003-01-14 16:40:25 Re: FATAL error on launch