Re: 7.4 - TODO : alter table drop foreign key
От | Dan Langille |
---|---|
Тема | Re: 7.4 - TODO : alter table drop foreign key |
Дата | |
Msg-id | 3DEF4979.30970.6B688D5@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 9:31, Stephan Szabo wrote: > When we talk about ALTER TABLE ADD FOREIGN KEY we're being imprecise, so > I think that might be why we're talking past each other here. > > Technically the syntax in question is: > ALTER TABLE <table> ADD <table constraint definition> > where CONSTRAINT <name> is an optional leading clause in a table > constraint definition. ADD FOREIGN KEY is a shorthand for a foreign key > constraint (technically unnamed). Understood. What about allowing a named foreign key? I haven't checked the RFCs > Thus you can also say things like: > ALTER TABLE <table> ADD CONSTRAINT blah CHECK (foo!=0); > to make a named check constraint. Understood. -- Dan Langille : http://www.langille.org/
В списке pgsql-hackers по дате отправления: