openGauss ERROR: inserted partition key does not map to any table partition Call getNextException to see other errors in the batch.

  • 2023/10/09
  • PostgreSQL/GaussDB
  • 105 views
  • openGauss ERROR: inserted partition key does not map to any table partition Call getNextException to see other errors in the batch.已关闭评论

opengauss系数据库insert失败因缺少匹配分区表，提示inserted partition key does not map to any table partition ，在oracle中一样存在该问题，建议月末或年末提前查询下个月的分区是否存在，匹配oracle的dba_tab_partitions,在postgresq 11后查询pg_partitioned_table,而在openGauss中查询pg_partition.

,

阅读全文