Re: How to add "on delete cascade" constraints

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: How to add "on delete cascade" constraints
Дата
Msg-id CAADeyWjQ+jyyRLzcBh04wkdfY2zHD489+Lfr4aU8MYgc6Y=kxw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to add "on delete cascade" constraints  (Richard Broersma <richard.broersma@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Thank you - this has worked perfectly

On Fri, Apr 27, 2012 at 10:18 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> You could, but you don't need to since you can do all of this is one statement:
>
> ALTER TABLE public.pref_scores
> DROP CONSTRAINT pref_scores_gid_fkey,
> ADD CONSTRAINT pref_scores_gid_fkey
>    FOREIGN KEY (gid)
>    REFERENCES pref_games(gid)
>    ON DELETE CASCADE;

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Broersma
Дата:
Сообщение: Re: How to add "on delete cascade" constraints
Следующее
От: Josh Kupershmidt
Дата:
Сообщение: Re: How to get the all the activities running during specific time range.Thanks!Plese help!