Partitioning existing table issue - Help needed!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux