Re: something weird happened - can select by column value although column value exist

2018-10-11 Thread Tom Lane
Ron writes: > On 10/11/2018 03:17 PM, Dmitry O Litvintsev wrote: >> Today the following happened: >> < 2018-10-11 13:31:52.587 CDT >ERROR: insert or update on table "file" >> violates foreign key constraint "$1" >> < 2018-10-11 13:31:52.587 CDT >DETAIL: Key (volume)=(155303) is not present >>

Re: something weird happened - can select by column value although column value exist

2018-10-11 Thread Ron
On 10/11/2018 03:17 PM, Dmitry O Litvintsev wrote: Hi, Today the following happened: Found this error in my production log: < 2018-10-11 13:31:52.587 CDT >ERROR: insert or update on table "file" violates foreign key constraint "$1" < 2018-10-11 13:31:52.587 CDT >DETAIL: Key (volume)=(155303

something weird happened - can select by column value although column value exist

2018-10-11 Thread Dmitry O Litvintsev
Hi, Today the following happened: Found this error in my production log: < 2018-10-11 13:31:52.587 CDT >ERROR: insert or update on table "file" violates foreign key constraint "$1" < 2018-10-11 13:31:52.587 CDT >DETAIL: Key (volume)=(155303) is not present in table "volume". < 2018-10-11 13