pgpartman/pg_partman issues and pull requests

#529 - exclusion constraint validation

Issue - State: closed - Opened by jw1u1 about 1 year ago - 8 comments
Labels: question

#528 - Support for uuid7 or ulid

Issue - State: open - Opened by dahu33 about 1 year ago - 10 comments
Labels: feature request, help wanted

#527 - Question : Migrating existing table

Issue - State: closed - Opened by anthares about 1 year ago - 3 comments
Labels: question

#523 - run_maintenance function fails to drop partition because of (replication set) dependency

Issue - State: closed - Opened by hrawulwa about 1 year ago - 4 comments
Labels: feature request, fixed in current release

#522 - dependency issues with python

Issue - State: closed - Opened by Tiago-Anastacio about 1 year ago - 3 comments
Labels: upstream issue

#520 - Doc error: publication inheritance was added in PG 13, not PG 14

Issue - State: closed - Opened by james-johnston-thumbtack about 1 year ago - 3 comments
Labels: confirmed bug, fixed in current release

#519 - partition_data_proc and run_maintenance with infinity timestamps

Issue - State: open - Opened by jw1u1 about 1 year ago - 13 comments
Labels: feature request

#517 - Integrate functions that underlay procedures directly into the procedure

Issue - State: closed - Opened by keithf4 over 1 year ago - 2 comments
Labels: feature request, on hold

#516 - Support for multi-column partitioning

Issue - State: open - Opened by keithf4 over 1 year ago - 1 comment
Labels: feature request

#515 - Create index removal procedure

Issue - State: open - Opened by keithf4 over 1 year ago - 4 comments
Labels: feature request

#514 - Create separate background worker to analyze partition sets

Issue - State: open - Opened by keithf4 over 1 year ago
Labels: feature request

#512 - Allow non-superuser installation

Issue - State: open - Opened by keithf4 over 1 year ago
Labels: feature request

#511 - Allow separate tablespace for child tables

Issue - State: open - Opened by keithf4 over 1 year ago
Labels: feature request

#510 - Updated partition constraint for default partition would be violated by some row

Issue - State: closed - Opened by vvitad over 1 year ago - 14 comments
Labels: question, requires submitter response

#509 - Allow partitions to be created in separate schema

Issue - State: open - Opened by revoohc over 1 year ago - 1 comment
Labels: feature request

#508 - pg 16 support

Pull Request - State: closed - Opened by RekGRpth over 1 year ago - 1 comment
Labels: fixed in current release

#507 - change p_control column for native partitioned table

Issue - State: closed - Opened by rodrigoparis over 1 year ago - 4 comments
Labels: requires submitter response

#505 - Create parent without template table using pg_partman

Issue - State: closed - Opened by kovalensue over 1 year ago - 8 comments
Labels: feature request, fixed in next release

#504 - can list-based partitions be automatically created?

Issue - State: closed - Opened by bsislow over 1 year ago - 18 comments

#503 - partition_gap_fill() fails for a table partitioned on timestamp

Issue - State: closed - Opened by xin-hedera over 1 year ago - 8 comments
Labels: confirmed bug, fixed in current release

#502 - REPLICA IDENTITY inheritance

Issue - State: closed - Opened by keithf4 over 1 year ago - 4 comments
Labels: feature request, fixed in current release

#500 - Update license file copyright to 2023

Pull Request - State: closed - Opened by youattd over 1 year ago

#499 - Remove PG11+ guard on retention_keep_index

Pull Request - State: closed - Opened by robertdecaire over 1 year ago - 6 comments
Labels: feature request, fixed in current release

#498 - Tests failures if using PG 15 for homebrew's test

Issue - State: closed - Opened by Porkepix over 1 year ago - 10 comments
Labels: upstream issue

#497 - Add a way to explicitly order table maintenance

Issue - State: closed - Opened by axelfaure over 1 year ago - 4 comments
Labels: feature request, fixed in current release

#496 - I don't think the SELECT... FOR UPDATE in partition_data_time.sql is locking any rows

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

#495 - Fix arg ref in SELECT FOR UPDATE format str

Pull Request - State: closed - Opened by nicwolff over 1 year ago - 1 comment

#494 - New columns etc in template tables

Issue - State: closed - Opened by amasses over 1 year ago - 4 comments
Labels: question

#493 - Future dated data inserted into default table, breaks run_maintenance

Issue - State: closed - Opened by amasses over 1 year ago - 4 comments
Labels: question

#492 - extension "pg_partman" has no installation script nor update path for version "4.7.1"

Issue - State: closed - Opened by abdoulayedrame over 1 year ago - 3 comments
Labels: question

#491 - Cannot create partition job_log and job_detail

Issue - State: closed - Opened by phuonghuynguyen over 1 year ago - 5 comments

#490 - Drop trigger-based partitioning support

Issue - State: closed - Opened by keithf4 over 1 year ago - 5 comments
Labels: feature request, fixed in current release

#489 - Make default partition optional (was: Avoiding "_default" partition)

Issue - State: closed - Opened by ultimoamore over 1 year ago - 5 comments
Labels: feature request, fixed in current release

#488 - EXTENSION UPDATE failed on ERROR: procedure partman.partition_data_proc does not exist

Issue - State: closed - Opened by kong1man almost 2 years ago - 2 comments
Labels: question

#487 - Partition maintenance breaks when any partitioned table name contains _p

Issue - State: closed - Opened by tsutsu almost 2 years ago - 5 comments
Labels: confirmed bug, fixed in current release

#486 - Offline partitioning is moving 0 rows at final step despite identical source and destination tables

Issue - State: closed - Opened by cathanod almost 2 years ago - 6 comments

#485 - partman running as non super user creates partition using postgres user

Issue - State: closed - Opened by saxenakshitiz almost 2 years ago - 4 comments
Labels: question, requires submitter response

#484 - pg_cron is detecting deleted table during CALL partman.run_maintenance_proc()

Issue - State: closed - Opened by gsrirangan almost 2 years ago - 2 comments
Labels: question

#483 - Support of Pg_partman for Hash Partition

Issue - State: closed - Opened by maheshetty20 almost 2 years ago - 4 comments
Labels: duplicate, question

#481 - retention_schema not working properly

Issue - State: closed - Opened by gsrirangan almost 2 years ago - 6 comments
Labels: confirmed bug, fixed in current release

#480 - Primary Key on template table and default partition

Issue - State: closed - Opened by tahseenbaig almost 2 years ago - 2 comments
Labels: feature request, question

#479 - Large Default Partition Question

Issue - State: closed - Opened by dtseiler almost 2 years ago - 3 comments
Labels: question

#478 - how to do IF NOT EXISTS ( SELECT partman.create_parent )

Issue - State: closed - Opened by Shanky-21 almost 2 years ago - 3 comments
Labels: question

#477 - How to install pg_partman in Windows 10?

Issue - State: closed - Opened by gsrirangan almost 2 years ago - 2 comments
Labels: question

#476 - Question: Partitioning existing table using partition_data_proc is taking a long time, and getting slower - is this expected?

Issue - State: closed - Opened by scooper91 almost 2 years ago - 4 comments
Labels: question

#474 - Fix run_maintenace when no default table exists

Pull Request - State: closed - Opened by sj26 almost 2 years ago - 9 comments
Labels: wontfix

#472 - PostgreSQL 15 compatibility

Pull Request - State: closed - Opened by hughcapet almost 2 years ago - 2 comments

#471 - Unable to drop partition if partitions are indexed using drop_partition_time function

Issue - State: closed - Opened by dbaprince almost 2 years ago - 4 comments
Labels: upstream issue

#470 - partman.create_parent p_premake not working as expected

Issue - State: closed - Opened by marian-gheorghe almost 2 years ago - 2 comments
Labels: question

#469 - pg 15 compatibility

Issue - State: closed - Opened by RekGRpth about 2 years ago - 3 comments
Labels: duplicate

#468 - Missing pgxs.mk in Docker installation

Issue - State: closed - Opened by jdcarey128 about 2 years ago - 7 comments
Labels: help wanted

#467 - Specify regex for background worker dbname

Issue - State: open - Opened by frankhommers about 2 years ago - 3 comments
Labels: feature request, help wanted

#466 - On retention copy data to different table and then drop.

Issue - State: closed - Opened by kegel2904 about 2 years ago - 3 comments
Labels: question, requires submitter response

#465 - Upgrading extension hangs

Issue - State: closed - Opened by devrimgunduz about 2 years ago - 10 comments
Labels: requires submitter response

#464 - PG15: pg_partman_bgw.so: undefined symbol: ProcessCompletedNotifies

Issue - State: closed - Opened by df7cb about 2 years ago - 3 comments
Labels: confirmed bug, fixed in current release

#463 - Run partition_data_proc in parallel

Issue - State: open - Opened by maxpain about 2 years ago - 2 comments
Labels: feature request, help wanted

#462 - Partman is creating empty partitions till the max value

Issue - State: closed - Opened by gouthasnm about 2 years ago - 7 comments
Labels: feature request, fixed in current release

#461 - pg_jobmon stopped working with 4.6.1

Issue - State: closed - Opened by Dakotah312 about 2 years ago - 7 comments
Labels: confirmed bug, fixed in current release

#460 - migrating existing partitioned table to pg_partman failed

Issue - State: closed - Opened by akshataraskar about 2 years ago - 4 comments
Labels: requires submitter response

#459 - drop_partition_time takes a very long time

Issue - State: closed - Opened by jorenvandeweyer about 2 years ago - 6 comments

#457 - Session level variables for BGW (Was: Create partitions with default access method)

Issue - State: open - Opened by gferrette about 2 years ago - 5 comments
Labels: feature request, help wanted

#456 - Analyze procedure for partitioned tables

Issue - State: closed - Opened by keithf4 about 2 years ago - 1 comment
Labels: feature request, fixed in current release

#455 - Table retention not working

Issue - State: closed - Opened by internetuser2008 about 2 years ago - 6 comments
Labels: question

#452 - partman.create_parent error ERROR: partition "testpartition_w_p2022w16" would overlap partition "testpartition_w_p220404"

Issue - State: closed - Opened by beginpgsql about 2 years ago - 2 comments
Labels: question

#451 - Error `missing separator` when running make install

Issue - State: closed - Opened by KidA001 about 2 years ago - 13 comments
Labels: question

#450 - Permission denied on schema partman when running create_parent()

Issue - State: closed - Opened by JerrySievert about 2 years ago - 22 comments
Labels: question

#449 - run_maintenance_proc() does not create new partitions

Issue - State: closed - Opened by s3dse about 2 years ago - 9 comments
Labels: pending review, requires submitter response

#447 - Not able to create partition if schema name contains '.'

Issue - State: closed - Opened by divyaJainPhilips over 2 years ago - 4 comments
Labels: wontfix

#446 - Oldest partition retention

Issue - State: closed - Opened by visciang over 2 years ago - 7 comments
Labels: confirmed bug, fixed in current release

#444 - Missing procedures in Azure

Issue - State: closed - Opened by jarrettprosser over 2 years ago - 2 comments

#443 - Honor drop_cascade_fk config

Pull Request - State: closed - Opened by lorenzo over 2 years ago

#442 - Review FK handling - (Renamed from: drop_cascade_fk is always ignored)

Issue - State: open - Opened by lorenzo over 2 years ago - 11 comments
Labels: feature request, pending review

#441 - Test that days retention works with weekly partitions

Pull Request - State: closed - Opened by jcoleman over 2 years ago - 1 comment

#440 - partition_data_proc taking too long to transfer the data

Issue - State: closed - Opened by harshil007 over 2 years ago - 1 comment

#437 - p_start_partition is not working as expected when using create_sub_parent

Issue - State: closed - Opened by ManisankarKanagasabapathy over 2 years ago - 1 comment
Labels: question

#435 - Fix locking rows when partitioning with a lock timeout

Pull Request - State: closed - Opened by cbisnett over 2 years ago - 1 comment
Labels: confirmed bug, fixed in current release

#432 - Changing the control column of the partitioned table.

Issue - State: closed - Opened by pratik97 over 2 years ago - 1 comment

#429 - Maintenance does not create future partitions

Issue - State: closed - Opened by nivbend over 2 years ago - 9 comments
Labels: question

#428 - Difficult to create tests of pg_partman partitioning application

Issue - State: closed - Opened by andylowry-turbo over 2 years ago - 3 comments
Labels: question

#427 - Function to ensure a partition exists for a given partition value

Issue - State: closed - Opened by andylowry-turbo over 2 years ago - 2 comments
Labels: question

#426 - Archiving function/script call when maintenance dropping partition?

Issue - State: closed - Opened by dtseiler over 2 years ago - 3 comments

#421 - Multiple partitioned tables interfere during maintenance

Issue - State: closed - Opened by nivbend over 2 years ago - 2 comments

#401 - Default partition is not included in publication

Issue - State: closed - Opened by james-johnston-thumbtack over 2 years ago - 2 comments
Labels: confirmed bug, fixed in current release

#395 - SQL error applying privileges to users with "." in name

Issue - State: closed - Opened by McCio over 2 years ago - 5 comments
Labels: confirmed bug, fixed in current release

#387 - Add support for CONCURRENT DETATCH in PG14

Issue - State: closed - Opened by keithf4 almost 3 years ago - 7 comments
Labels: wontfix

#378 - Is there a way to direct dropped partitions into another (partitioned) archive table?

Issue - State: closed - Opened by Aweptimum almost 3 years ago - 9 comments
Labels: question

#353 - Allow batching partition_data_* for native partitioning (Was: partition_data_* did not move the data out of the default partition)

Issue - State: open - Opened by cobolbaby about 3 years ago - 20 comments
Labels: feature request

GitHub / pgpartman/pg_partman issues and pull requests