Table restructuring with referential integrity - Mailing list pgsql-general

From Mihai Gheorghiu
Subject Table restructuring with referential integrity
Date
Msg-id 000301c160b3$96dc0a60$6e646464@New6.Travel
Whole thread Raw
Responses Re: Table restructuring with referential integrity  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
I have two tables t1 and t2, which have a referential integrity defined like
t2 references t1. I need to re-create t1, because I'm changing the field
structure (dropping fields included). So I do a drop t1 followed by a new
create t1. When I drop t1, I get a notice that the referential integrity
trigger will be implicitly dropped from t2. Does this mean that I have to
re-create t2 too?
Thank you all.



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: concurrency performance degradation
Next
From: Tom Lane
Date:
Subject: Re: Select limit... erm so..