Modifying a table that other tables refer to for foreigh key

From: "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Modifying a table that other tables refer to for foreigh key
Date: 2001-05-29 18:35:26
Message-ID: 000501c0e86e$2a52f420$6e646464@New6.Travel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a database with multiple referential integrity links.
I want to make important changes to one of the tables, which is referenced
by other tables for foreign keys (like deleting some columns, or changing
data type).
What would be the easiest way to do it (without re-creating all the other
tables that are refering to it)?
Thanks in advance,
Mihai

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2001-05-29 19:01:14 Re: Installing 7.1.2 over 7.1.0
Previous Message Gilbert Wong 2001-05-29 17:57:34 Timezones on HPUX