Postgres Pro
Downloads
Home   >   mailing lists

Re: Modifying a foreign key constraint? - Mailing list pgsql-general

From Marc Branchaud
Subject Re: Modifying a foreign key constraint?
Date
Msg-id 45CC9AD5.5060103@x2omedia.com
Whole thread Raw
List pgsql-general
Tree view 
Whoops,

> ALTER TABLE foo ADD FOREIGN KEY (foo_bar_id_fkey) REFERENCES bar(id) ON
> DELETE CASCADE;

should be

ALTER TABLE foo ADD FOREIGN KEY (bar_id) REFERENCES bar(id) ON DELETE
CASCADE;

Sorry!

        Marc

pgsql-general by date:

Previous
From: johnf
Date:
Subject: Re: does anyone have a tool to convert SP'sT-SQL to Postgres
Next
From: Marc Branchaud
Date:
Subject: Modifying a foreign key constraint?