Re: Problem about partitioned table

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(dot)klaver(at)aklaver(dot)com