Re: Constants in the foreighn key constraints

2019-11-25 Thread aleksey ksenzov
t; > Please reply to list also. > > Ccing list. > > > On 11/22/19 11:36 PM, aleksey ksenzov wrote: > >> While I understand I can do everything with triggers/functions, for me > >> it looks like a good idea to have possibility to use constants in > >> constrain

Constants in the foreighn key constraints

2019-11-22 Thread aleksey ksenzov
Hi team. Latest time we faced several issues which wouldn't arise provided we have possibility to use constants in foreign key constraints. brief example where it would be helpful: table_a ( id uuid, parent_id uuid, is_deleted boolean ) having possibility of FK (parent_id, false) to (id, is_delete