| From: | amul sul <sulamul(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Cannot dump foreign key constraints on partitioned table |
| Date: | 2018-07-11 10:19:59 |
| Message-ID: | CAAJ_b94n=UsNVhgs97vCaWEZAMe-tGDRVuZ73oePQH=eaJKGSA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On the master head, getConstraints() function skips FK constraints for
a partitioned table because of tbinfo->hastriggers is false.
While creating FK constraints on the partitioned table, the FK triggers are only
created on leaf partitions and skipped for the partitioned tables.
To fix this, either bypass the aforementioned condition of getConstraints() or
set pg_class.relhastriggers to true for the partitioned table which doesn't seem
to be the right solution, IMO. Thoughts?
Regards,
Amul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2018-07-11 10:31:45 | Re: Negotiating the SCRAM channel binding type |
| Previous Message | Ashutosh Bapat | 2018-07-11 09:36:24 | partition pruning doesn't work with IS NULL clause in multikey range partition case |