Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group