pgpartman/pg_partman issues and pull requests

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

Issue - State: open - Opened by databasetech0073 22 days ago - 3 comments
Labels: question

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

Issue - State: closed - Opened by Thavarajan 22 days ago - 1 comment
Labels: duplicate

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

Issue - State: closed - Opened by CharlesLiu02 23 days ago

#662 - Avoid scanning non-default partitions

Pull Request - State: open - Opened by nicolagi about 1 month ago - 1 comment
Labels: feature request, pending review

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

Issue - State: closed - Opened by boarnoah about 1 month ago - 3 comments
Labels: question

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

Issue - State: open - Opened by nicolagi about 1 month ago - 10 comments
Labels: feature request

#659 - allow microsecond precision for epoch

Pull Request - State: open - Opened by agdolla about 1 month ago - 2 comments
Labels: feature request

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

Issue - State: open - Opened by mingravity about 2 months ago - 1 comment
Labels: confirmed bug

#656 - Partition making problem

Issue - State: closed - Opened by Mohammad-Safaie-1999 2 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 2 months ago - 7 comments

#653 - ERROR: timestamp out of range

Issue - State: closed - Opened by SukeshKrk 2 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 3 months ago - 2 comments

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

Issue - State: open - Opened by Woodz 3 months ago - 6 comments
Labels: requires submitter response

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

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

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

Issue - State: open - Opened by nicolagi 3 months ago - 1 comment
Labels: feature request, pending review

#648 - maintenance_last_run column not present in part_config table

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

#646 - Installation on windows

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

#645 - Can't install pg_partman on Heroku Postgresql

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

#643 - No foreign key support on template based partitioning

Issue - State: open - Opened by Asafb26 3 months ago

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

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

#641 - Support numeric partitioning

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

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

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

#639 - Unable to migrate data from different schema

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

#637 - Drop default_table column from part_config

Issue - State: open - Opened by keithf4 4 months ago
Labels: pending review

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

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

#633 - FK Errors on partition_data_proc version 4.7.3

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

#632 - CLUSTER under the Offline portion?

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

#631 - is it safe to truncate default table

Issue - State: closed - Opened by seadba 4 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 4 months ago

#627 - run_maintenance_proc() Not Working as Expected

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

#626 - Long running queries and partman.run_maintenance_proc

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

#624 - Change partition key in existing table

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

#623 - Trying to use ignore_default_data for running maintenance

Issue - State: closed - Opened by rezonick 5 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 5 months ago - 5 comments
Labels: question

#618 - Qualify partition_gap_fill with @extschema@

Pull Request - State: closed - Opened by nicolagi 5 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 5 months ago - 2 comments

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

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

#615 - 5.1.0 beta & 4.8.0

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

#614 - DETACH PARTITION CONCURRENTLY

Pull Request - State: closed - Opened by jw1u1 5 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 5 months ago - 2 comments

#611 - Update copyright range to include 2024

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

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

Issue - State: closed - Opened by OlegUfaev 6 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 6 months ago - 5 comments

#607 - Make table analyze controlled by parameter in partition_gab_fill func…

Pull Request - State: closed - Opened by aleszeleny 6 months ago - 1 comment
Labels: fixed in next release

#606 - Bug in partition_gap_fill() in 4.7.4

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

#605 - run_maintenance_proc() not creating new partitions

Issue - State: closed - Opened by Shanky-21 6 months ago - 6 comments
Labels: question, answered

#604 - long time to create partition tables

Issue - State: closed - Opened by joyful88 6 months ago - 10 comments
Labels: fixed in current release

#603 - Partman don't create new partition

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

#602 - v5.0.1 fix edge case condition when upgrading to version 5

Pull Request - State: closed - Opened by keithf4 6 months ago
Labels: confirmed bug

#601 - Encountered a Fatal Error During PostgreSQL Server Restart:

Issue - State: closed - Opened by bigil 6 months ago - 2 comments
Labels: question

#599 - Error while upgrading extention from 4.6.2 to 5.0.0

Issue - State: closed - Opened by hyde1 7 months ago - 29 comments
Labels: confirmed bug, fixed in current release

#598 - Unexpected behavior of infinite_time_partitions=true when no data is inserted

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

#597 - p_start_partition generates wrong first partition date

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

#596 - Error installing on macOS 14.0 - Operation not permitted make: *** [install] Error 71

Issue - State: closed - Opened by erielias 7 months ago - 6 comments
Labels: question, answered

#595 - ERROR: function partman.undo_partition_time does not exis

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

#594 - Fix doc formatting

Pull Request - State: closed - Opened by mbanck 7 months ago - 1 comment

#593 - create_parent: allow nullable control column if p_default_table is true

Pull Request - State: closed - Opened by madand 7 months ago - 5 comments

#592 - Different Index Name on Child Table

Issue - State: closed - Opened by aakashmuthuramalingam 7 months ago - 5 comments
Labels: question, answered

#591 - Annotating markdown snippets as SQL for easier reading

Pull Request - State: closed - Opened by fragkakis 8 months ago - 2 comments

#590 - Inheritance table no longer does 'no inherit'

Issue - State: closed - Opened by rsquaretrade 8 months ago - 9 comments
Labels: fixed in current release

#589 - Allow overriding of pg_config

Pull Request - State: closed - Opened by ChuckHend 8 months ago - 4 comments

#586 - ERROR: Child table given does not exist (schema_1.log_table1_p2023_12) while running maintenance proc

Issue - State: closed - Opened by UtkarshDixit6 8 months ago - 1 comment

#585 - Allow infinite_time_partitions flag to work even if zero data in partition set

Issue - State: closed - Opened by mbrancato 8 months ago - 14 comments
Labels: feature request, fixed in current release

#584 - Handle foreign keys to dropped child tables

Issue - State: open - Opened by keithf4 8 months ago - 5 comments
Labels: feature request, pending review

#583 - Provide Checksum for GitHub Archives

Issue - State: open - Opened by Morl99 8 months ago - 1 comment
Labels: feature request

#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 9 months ago - 1 comment
Labels: confirmed bug, fixed in current release

GitHub / pgpartman/pg_partman issues and pull requests