Partitioning existing table issue - Help needed! - Mailing list pgsql-admin

From dbatoCloud Solution
Subject Partitioning existing table issue - Help needed!
Date
Msg-id CAEz7P_v93GF4_irRugWvz7SrCNVHFEihEbuotaDJGu=WGyWbpQ@mail.gmail.com
Whole thread Raw
Responses Re: Partitioning existing table issue - Help needed!
Re: Partitioning existing table issue - Help needed!
List 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

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Design database
Next
From: Magnus Hagander
Date:
Subject: Re: Partitioning existing table issue - Help needed!