On 10/19/18 2:03 AM, Mehman Jafarov wrote:
Hi everyone,
I have a problem with partitioned table in PostgreSql.
Actually I use the version 10. I created the partitioned table in test
environment but face some problems with partitioned table constraint.
I google all about it last week and from the official site I get that
version 11 will be released and that feature will be supported as I
understand it.
From version 11 documentation
"/Add support for |PRIMARY KEY|, |FOREIGN KEY|, indexes, and triggers on
partitioned tables/"
I install and configure yesterday as new 11 version released. And test
it. Unfortunately I didn't achieve again.
Neither I don't understand the new feature nor this case is actually not
supported.
Please help me about the problem.
As you found out:
https://www.postgresql.org/docs/11/static/ddl-partitioning.html
5.10.2.3. Limitations
"While primary keys are supported on partitioned tables, foreign keys
referencing partitioned tables are not supported. (Foreign key
references from a partitioned table to some other table are supported.)"
Note: I want to create constraint only one-to-one column
(/fk_to_user_doc_rel - oid/)
BIG QUESTION IS THAT
How can I solve this problem? What is your recommendations?
Well a FK is a form of a trigger, so maybe create your own trigger on
the child table(s).
*PLEASE HELP ME !!!*
--
*/Best Regards,/*
*/Mehman Jafarov/*
*/DBA Aministrator at CyberNet LLC/*
*/
/*
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
