Re: drop table and references

Поиск
Список
Период
Сортировка
Искать
От
Stephan Szabo
Тема
Re: drop table and references
Дата
Msg-id
Pine.BSF.4.21.0101091501080.69680-100000@megazone23.bigpanda.com
Ответ на
drop table and references (Martin A. Marques)
Список
Дерево обсуждения
drop table and references "Martin A. Marques" <martin@math.unl.edu.ar>
Re: drop table and references Miles Thompson <milesthompson@sprint.ca>
Re: drop table and references Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: drop table and references "Martin A. Marques" <martin@math.unl.edu.ar> 

On Tue, 9 Jan 2001, Martin A. Marques wrote:

> I have a big doubt. If I drop a table with a primary key to which other 
> tables reference to, what happens? And If I create the table again, just as 
> it was, but maybe with another column?

Theoretically (ie, assuming no bugs), when you drop the table the foreign
key constraints are dropped as well.  If you recreate the table the
constraints are not recreated, you'd have to use ALTER TABLE ADD
CONSTRAINT to make them again.
В списке pgsql-general по дате отправления
Предыдущее
От: Andrew W. Nosenko
Дата:
Следующее
От: Tom Lane
Дата:
FAQ