On Fri, 2003-09-19 at 11:09, Jean-Christian Imbeault wrote: > Currently I have a table defined as such: > > TAL=# \d internal_keywords > Table "public.internal_keywords" > Column | Type | Modifiers > ---------+---------+----------- > keyword | text | not null > pid | integer | not null > Indexes: internal_keywords_pkey primary key btree (keyword, pid) > Foreign Key constraints: $1 FOREIGN KEY (pid) REFERENCES products(id) ON > UPDATE NO ACTION ON DELETE NO ACTION > > How can I change the ON DELETE action to CASCADE for column pid? > > I've check the alter table documentation but cannot find any reference > to this.
Drop the constraint; then add an amended one. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Bring ye all the tithes into the storehouse, that there may be meat in mine house, and prove me now herewith, saith the LORD of hosts, if I will not open you the windows of heaven, and pour you out a blessing, that there shall not be room enough to receive it." Malachi 3:10 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
