Re: [GENERAL] CHECK for 2 FKs to be non equal

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: [GENERAL] CHECK for 2 FKs to be non equal
Дата
Msg-id CAADeyWhAnBmbniSCa+6pr_7hXV4wKFZGcy6F4+aqi0iAuuKSUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] CHECK for 2 FKs to be non equal  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general
Thank you Alban and Francisco -

On Sat, Mar 11, 2017 at 11:52 AM, Alban Hertroys <haramrae@gmail.com> wrote:
> On 11 Mar 2017, at 10:41, Alexander Farber <alexander.farber@gmail.com> wrote:
>          uid integer NOT NULL REFERENCES words_users(uid) CHECK (uid <> author) ON DELETE CASCADE,


You put your CHECK constraint definition smack in the middle of the FK constraint definition, which starts with REFERENCES and ends with the delete CASCADE.


you are both correct!

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: [GENERAL] CHECK for 2 FKs to be non equal
Следующее
От: SuperCiccio
Дата:
Сообщение: [GENERAL] Index using in jsonb query