pgpartman/pg_partman issues and pull requests

#708 - Is pg_partman affected by the recent PG ABI breakage?

Issue - State: closed - Opened by dtseiler 2 days ago - 2 comments
Labels: question, answered

#707 - partman is not creating partition

Issue - State: open - Opened by ithirisece 2 days ago - 4 comments
Labels: question

#706 - Request: undo_parent

Issue - State: open - Opened by Faithfinder 3 days ago - 7 comments
Labels: feature request

#705 - run_maintenance continuously creates partitions

Issue - State: open - Opened by CharlesLiu02 6 days ago - 1 comment
Labels: requires submitter response

#704 - LIST partitioned table does not get new partitions with run_maintenance* calls

Issue - State: open - Opened by keithf4 9 days ago - 7 comments
Labels: confirmed bug, fixed in current release

#701 - Creating partitions is missing INCLUDING STATISTICS

Issue - State: open - Opened by wulczer 17 days ago - 5 comments
Labels: feature request, fixed in current release

#698 - Question: Managing per-partition unique constraints with template table

Issue - State: closed - Opened by jbbeal about 1 month ago - 4 comments
Labels: requires submitter response

#697 - Question - Can the metadata table be updated after manually deleting the partitioned table

Issue - State: closed - Opened by zthhhhh about 1 month ago - 2 comments
Labels: question

#696 - Partitions getting detached from parent table as separate tables

Issue - State: closed - Opened by mudasirmirza about 1 month ago - 3 comments
Labels: question, answered

#695 - Question - Why should sub-partition interval be smaller than parent interval

Issue - State: open - Opened by fobbing about 2 months ago - 6 comments
Labels: feature request

#694 - exclusion constraint miscalculation

Issue - State: open - Opened by jw1u1 about 2 months ago - 6 comments
Labels: confirmed bug, fixed in current release

#692 - Parent Table Not Archived When Running pg_partman Maintenance

Issue - State: open - Opened by anjay-gupta 2 months ago - 2 comments
Labels: requires submitter response

#690 - Is it possible to create older version of pg_partman rather than new version

Issue - State: closed - Opened by Durgamahesh671 2 months ago - 1 comment
Labels: question, answered

#688 - create_parent not working if p_parent_table capitalized

Issue - State: closed - Opened by ogurashi 3 months ago - 6 comments
Labels: question, answered

#686 - Partition by epoch millseconds not correct

Issue - State: closed - Opened by mopooo 3 months ago - 4 comments
Labels: requires submitter response

#685 - Range-Hash Subpartioning support in pg_partman

Issue - State: closed - Opened by hrawulwa 3 months ago - 7 comments
Labels: duplicate

#683 - Feature: add support for text and uuid type control columns

Pull Request - State: closed - Opened by akulapid 3 months ago - 18 comments
Labels: feature request

#682 - future partition possibility

Issue - State: closed - Opened by seadba 3 months ago - 3 comments
Labels: question

#681 - Is There a Solution to Reattach Multiple Partitions for a Date Range Once detached?

Issue - State: closed - Opened by aamish-DMS 4 months ago - 1 comment
Labels: question, answered

#680 - Error when partition_data_proc is called more than one time

Issue - State: closed - Opened by lbazetto 4 months ago - 7 comments
Labels: question, answered

#679 - Fix link to CHANGELOG

Pull Request - State: closed - Opened by mhagander 4 months ago - 1 comment

#678 - Possible to perform ACCESS EXCLUSIVE actions at the end of maintenance?

Issue - State: open - Opened by mplanchard 4 months ago - 10 comments
Labels: feature request, fixed in current release

#677 - Regarding run_maintenance_proc() with concurrently option for detaching tables

Issue - State: open - Opened by Durgamahesh671 4 months ago - 1 comment
Labels: feature request, help wanted

#676 - Changing cluster parameters does not take effect. (问题)更改集群参数后不生效

Issue - State: closed - Opened by rayn316 4 months ago

#674 - Non-key index columns are not properlly inherited from template table

Issue - State: open - Opened by C0mbatwombat 4 months ago - 1 comment
Labels: pending review

#673 - Issues with the partition control column being NOT NULL constraint

Issue - State: open - Opened by gowdh 4 months ago - 12 comments
Labels: feature request, fixed in current release

#671 - Add CI test and PGXN release workflows

Pull Request - State: closed - Opened by theory 5 months ago - 11 comments
Labels: feature request

#670 - Add `lint` make target and run pre-commit

Pull Request - State: closed - Opened by theory 5 months ago

#669 - Issue with dashes in schema name when calling create_parent function: ""staging-boo-foo"" does not exist.

Issue - State: closed - Opened by alizdavoodi 5 months ago - 11 comments
Labels: question, answered

#668 - pg_partman issue in case of table relationship exists

Issue - State: closed - Opened by databasetech0073 5 months ago - 6 comments
Labels: requires submitter response

#667 - pg_partman doesn't maintain the order of execution of tables

Issue - State: closed - Opened by databasetech0073 6 months ago - 4 comments
Labels: question, answered

#665 - Missing Records while trasfer data from old table to new table

Issue - State: closed - Opened by Thavarajan 6 months ago - 1 comment
Labels: duplicate

#664 - Need to migrate large amount of data from default

Issue - State: closed - Opened by CharlesLiu02 6 months ago

#662 - Avoid scanning non-default partitions

Pull Request - State: closed - Opened by nicolagi 6 months ago - 1 comment
Labels: feature request, pending review

#661 - datetime_string format isn't followed by all functions

Issue - State: closed - Opened by boarnoah 6 months ago - 3 comments
Labels: question

#660 - Avoid `SELECT MAX(control)` queries

Issue - State: open - Opened by nicolagi 6 months ago - 20 comments
Labels: feature request, fixed in current release

#659 - allow microsecond precision for epoch

Pull Request - State: closed - Opened by agdolla 6 months ago - 2 comments
Labels: feature request

#657 - Partition creation fails when partial indexes are present with tablespace

Issue - State: open - Opened by mingravity 7 months ago - 3 comments
Labels: confirmed bug, fixed in current release

#656 - Partition making problem

Issue - State: closed - Opened by Mohammad-Safaie-1999 7 months ago - 3 comments
Labels: question, requires submitter response

#655 - call partman.partition_data_proc during partman.run_maintenance

Issue - State: closed - Opened by hvanderland 7 months ago - 7 comments

#653 - ERROR: timestamp out of range

Issue - State: closed - Opened by SukeshKrk 7 months ago - 15 comments
Labels: question

#652 - ERROR: updated partition constraint for default partition "int_taptest_table_default" would be violated by some row.

Issue - State: closed - Opened by tranicus 7 months ago - 2 comments

#651 - `undo_partition` needs to be called twice if there is data in the partitions

Issue - State: closed - Opened by Woodz 8 months ago - 7 comments
Labels: requires submitter response

#650 - Do not create partitions that are not to be retained

Pull Request - State: closed - Opened by nicolagi 8 months ago - 4 comments
Labels: feature request

#649 - Do not create partitions that are not to be retained

Issue - State: open - Opened by nicolagi 8 months ago - 4 comments
Labels: feature request, fixed in current release

#648 - maintenance_last_run column not present in part_config table

Issue - State: closed - Opened by sanjay-motorq 8 months ago - 2 comments

#646 - Installation on windows

Issue - State: closed - Opened by Mohammad-Safaie-1999 8 months ago - 1 comment
Labels: question, answered

#645 - Can't install pg_partman on Heroku Postgresql

Issue - State: closed - Opened by jeremyhaile 8 months ago - 6 comments
Labels: question, answered

#643 - No foreign key support on template based partitioning

Issue - State: open - Opened by Asafb26 8 months ago - 1 comment

#642 - unknown argument: '-no-opaque-pointers'

Issue - State: closed - Opened by kbiba3 8 months ago - 5 comments
Labels: question

#641 - Support numeric partitioning

Issue - State: closed - Opened by Asafb26 8 months ago - 1 comment
Labels: duplicate

#640 - Missing partitions after running partition_data_proc() then run_maintenance()

Issue - State: closed - Opened by jeanloesch 8 months ago - 2 comments
Labels: question, answered

#639 - Unable to migrate data from different schema

Issue - State: closed - Opened by Darkbladecr 9 months ago - 6 comments
Labels: confirmed bug, fixed in current release

#637 - Drop default_table column from part_config

Issue - State: closed - Opened by keithf4 9 months ago
Labels: fixed in current release

#635 - Issue running multiple updates on partitioned table in a single transaction.

Issue - State: open - Opened by mraasvel 9 months ago - 2 comments
Labels: help wanted

#633 - FK Errors on partition_data_proc version 4.7.3

Issue - State: closed - Opened by Asafb26 9 months ago - 2 comments
Labels: question, answered

#632 - CLUSTER under the Offline portion?

Issue - State: closed - Opened by andyatkinson 9 months ago - 2 comments
Labels: fixed in current release, documentation

#631 - is it safe to truncate default table

Issue - State: closed - Opened by seadba 9 months ago - 6 comments
Labels: question

#628 - Is there a recommended pg_partman naming convention for integer range partitioning?

Issue - State: closed - Opened by rgidds 9 months ago

#627 - run_maintenance_proc() Not Working as Expected

Issue - State: closed - Opened by Davide3i 10 months ago - 3 comments
Labels: question

#626 - Long running queries and partman.run_maintenance_proc

Issue - State: closed - Opened by mattpoel 10 months ago - 2 comments
Labels: question, answered

#624 - Change partition key in existing table

Issue - State: closed - Opened by geoemm 10 months ago - 4 comments
Labels: question

#623 - Trying to use ignore_default_data for running maintenance

Issue - State: closed - Opened by rezonick 10 months ago - 2 comments
Labels: question, answered

#620 - v4.7.3: CALL partman.run_maintenance_proc() - ERROR: updated partition constraint for default partition "consumption_default" would be violated by some row

Issue - State: closed - Opened by braquino 10 months ago - 5 comments
Labels: question

#618 - Qualify partition_gap_fill with @extschema@

Pull Request - State: closed - Opened by nicolagi 10 months ago - 2 comments
Labels: confirmed bug

#617 - Future partitions not created despite infinite_time_partitions set to true

Issue - State: closed - Opened by mattpoel 10 months ago - 2 comments

#616 - Use the partition_gap_fill() parameter p_analyze in partition creation

Pull Request - State: closed - Opened by aleszeleny 10 months ago

#615 - 5.1.0 beta & 4.8.0

Pull Request - State: closed - Opened by keithf4 10 months ago
Labels: in development

#614 - DETACH PARTITION CONCURRENTLY

Pull Request - State: closed - Opened by jw1u1 10 months ago - 1 comment
Labels: requires submitter response

#613 - System not letting me to change pg_partman_bgw.analyze to on.

Issue - State: closed - Opened by ToxicalNoob3062 10 months ago - 2 comments

Pull Request - State: closed - Opened by youattd 10 months ago - 1 comment
Labels: duplicate

#609 - It should be possible to specify tablespace for table partitions

Issue - State: closed - Opened by OlegUfaev 11 months ago - 21 comments
Labels: confirmed bug, fixed in current release

#608 - Can I create pg_partman extension to 4.7.2 (vs 5.0) due to "ERROR: native is not a valid partitioning type for pg_partman"

Issue - State: closed - Opened by rsquaretrade 11 months ago - 5 comments

#579 - partman.run_maintenance_proc() not maintaining new partitions for a id based partitioned table when data is in default table.

Issue - State: closed - Opened by asranand7 about 1 year ago - 1 comment
Labels: confirmed bug, fixed in current release

GitHub / pgpartman/pg_partman issues and pull requests