Table restructuring with referential integrity

Поиск
Список
Период
Сортировка
От Mihai Gheorghiu
Тема Table restructuring with referential integrity
Дата
Msg-id 000301c160b3$96dc0a60$6e646464@New6.Travel
обсуждение исходный текст
Ответы Re: Table restructuring with referential integrity  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: concurrency performance degradation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Select limit... erm so..