Re: Modifying a foreign key constraint?

From: Marc Branchaud <marcnarc(at)x2omedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Modifying a foreign key constraint?
Date: 2007-02-09 16:01:25
Message-ID: 45CC9AD5.5060103@x2omedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message johnf 2007-02-09 16:01:29 Re: does anyone have a tool to convert SP'sT-SQL to Postgres
Previous Message Marc Branchaud 2007-02-09 15:57:37 Modifying a foreign key constraint?