Re: FKs on partitioned tables

2022-09-27 Thread 'Maria Fradkin' via sequel-talk
It is working nicely!! Thank you so much! On Tuesday, September 27, 2022 at 4:38:01 PM UTC-4 Jeremy Evans wrote: > On Tue, Sep 27, 2022 at 12:46 PM 'Maria Fradkin' via sequel-talk < > seque...@googlegroups.com> wrote: > >> Hello, >> >> I have recently came across a problem with foreign_key_list

Re: FKs on partitioned tables

2022-09-27 Thread Jeremy Evans
On Tue, Sep 27, 2022 at 12:46 PM 'Maria Fradkin' via sequel-talk < sequel-talk@googlegroups.com> wrote: > Hello, > > I have recently came across a problem with foreign_key_list not working > correctly with partitioned tables on Postgres. > My table is partitioned by hash on some_id column, I have

FKs on partitioned tables

2022-09-27 Thread 'Maria Fradkin' via sequel-talk
Hello, I have recently came across a problem with foreign_key_list not working correctly with partitioned tables on Postgres. My table is partitioned by hash on some_id column, I have few partitions attached some_table_p_hash_p1 some_table_p_hash_p2 ... some_table_p_hash_p16 the table has f