Re: 7.4 - TODO : alter table drop foreign key
От | Dan Langille |
---|---|
Тема | Re: 7.4 - TODO : alter table drop foreign key |
Дата | |
Msg-id | 3DEF3861.24289.673BE7F@localhost обсуждение исходный текст |
Ответ на | Re: 7.4 - TODO : alter table drop foreign key (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: 7.4 - TODO : alter table drop foreign key
|
Список | pgsql-hackers |
On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > We support "alter table add foreign key". How about supporting > > "alter table drop foreign key"? > > > > - he said as he went to drop a foreign key > > It seems to work for me on my 7.3b2 system with > alter table <table> drop constraint <constraint name>; Premature send.. sorry How was that FK added? How did you determine the constraint name? How would you do that if the FK was added with the following syntax? alter table <table> add foreign key (<column>) references <othertable> (<othercolumn>) on update cascade on delete cascade; -- Dan Langille : http://www.langille.org/
В списке pgsql-hackers по дате отправления: