Partitioning existing table issue - Help needed!

From: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Partitioning existing table issue - Help needed!
Date: 2021-02-04 13:47:48
Message-ID: CAEz7P_v93GF4_irRugWvz7SrCNVHFEihEbuotaDJGu=WGyWbpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear All,

I am partitioning the large table using declarative partitioning method in
PostgreSQL 10.13.

The below steps which I am using are :

1. created parent table
2. create sub-partitioned table
3. created index for each partition
4. created function
5. creating trigger but end with below error:-

SQL Error [42809]: ERROR: "contact_transaction_history_parent_part_bkp_am"
is a partitioned table

Detail: Partitioned tables cannot have ROW triggers.

Please let me know what is the issue with this?

Kindly advise.

Regards,

AShok

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2021-02-04 14:10:40 Re: Partitioning existing table issue - Help needed!
Previous Message hubert depesz lubaczewski 2021-02-03 16:44:59 Re: Design database