/dports/databases/pg_partman/pg_partman-4.5.1/test/ |
H A D | test-id-time-subpart.sql | 351 UPDATE part_config SET retention = '10', retention_keep_table = false WHERE parent_table = 'partman… 352 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 353 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 354 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 355 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 356 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 357 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 358 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par…
|
H A D | test-time-id-subpart.sql | 508 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 509 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 510 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 511 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 512 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 513 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 514 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 515 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 516 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 517 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman…
|
H A D | test-time-weekly-daily-subpart.sql | 648 UPDATE part_config SET retention = '2 weeks', retention_keep_table = false WHERE parent_table LIKE … 667 UPDATE part_config SET retention = '3 days', retention_keep_table = true, retention_keep_index = fa… 682 UPDATE part_config SET retention = '7 days', retention_keep_table = false WHERE parent_table = 'Par… 684 UPDATE part_config SET retention = NULL, retention_keep_table = false WHERE parent_table LIKE 'Part…
|
H A D | test-id-mixed-case.sql | 318 UPDATE part_config SET retention = '50000', retention_keep_table = false WHERE parent_table = 'Part…
|
/dports/databases/pg_partman/pg_partman-4.5.1/test/test_upsert/ |
H A D | test-id-time-subpart-upsert-do-nothing.sql | 360 UPDATE part_config SET retention = '10', retention_keep_table = false WHERE parent_table = 'partman… 361 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 362 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 363 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 364 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 365 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 366 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 367 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par…
|
/dports/databases/pg_partman/pg_partman-4.5.1/test/test_native/ |
H A D | test-time-epoch-id-subpart-native.sql | 540 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 541 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 542 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 543 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 544 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 545 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 546 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 547 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 548 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 549 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman…
|
H A D | test-time-id-subpart-native.sql | 538 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 539 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 540 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 541 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 542 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 543 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 544 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 545 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 546 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman… 547 UPDATE part_config SET retention = '25', retention_keep_table = false WHERE parent_table = 'partman…
|
H A D | test-id-time-subpart-native.sql | 442 UPDATE part_config SET retention = '10', retention_keep_table = false WHERE parent_table = 'partman… 443 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 444 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 445 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 446 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 447 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 448 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 449 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par…
|
H A D | test-id-time-subpart-custom-start-native.sql | 482 UPDATE part_config SET retention = '10', retention_keep_table = false WHERE parent_table = 'partman… 483 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 484 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 485 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 486 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 487 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 488 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par… 489 UPDATE part_config SET retention = '2 days', retention_keep_table = false WHERE parent_table = 'par…
|
H A D | test-dump-definition.sql | 55 SET retention='5 weeks', retention_keep_table = 'f', infinite_time_partitions = 't' 127 SET retention='5 weeks', retention_keep_table = 'f', infinite_time_partitions = 't', constraint_val…
|
/dports/databases/pg_partman/pg_partman-4.5.1/updates/ |
H A D | pg_partman--0.1.2--0.2.0.sql | 8 ALTER TABLE @extschema@.part_config ADD retention_keep_table boolean NOT NULL DEFAULT true; 53 , retention_keep_table 210 , retention_keep_table
|
H A D | pg_partman--1.2.0--1.3.0.sql | 410 , retention_keep_table 432 , retention_keep_table 610 , retention_keep_table 632 , retention_keep_table
|
H A D | pg_partman--1.8.2--1.8.3.sql | 321 , retention_keep_table 347 , retention_keep_table 719 , retention_keep_table = v_row.sub_retention_keep_table 1070 , retention_keep_table = v_row.sub_retention_keep_table
|
H A D | pg_partman--1.1.0--1.2.0.sql | 53 , retention_keep_table 73 , retention_keep_table 248 , retention_keep_table 268 , retention_keep_table
|
H A D | pg_partman--4.1.0--4.2.0.sql | 1100 , retention_keep_table = v_row.sub_retention_keep_table 1571 , retention_keep_table = v_row.sub_retention_keep_table 1703 , retention_keep_table 1731 , retention_keep_table 1994 , retention_keep_table 2019 , retention_keep_table
|
H A D | pg_partman--1.8.0--1.8.1.sql | 433 , retention_keep_table = v_row.sub_retention_keep_table 784 , retention_keep_table = v_row.sub_retention_keep_table
|
H A D | pg_partman--4.2.2--4.3.0.sql | 769 , retention_keep_table = v_row.sub_retention_keep_table 1140 , retention_keep_table = v_row.sub_retention_keep_table 2261 pc.retention_keep_table, 2459 , retention_keep_table 2487 , retention_keep_table 2755 , retention_keep_table 2780 , retention_keep_table
|
H A D | pg_partman--2.3.1--2.3.2.sql | 835 , retention_keep_table = v_row.sub_retention_keep_table 1163 , retention_keep_table = v_row.sub_retention_keep_table 2161 , retention_keep_table 2185 , retention_keep_table 2415 , retention_keep_table 2441 , retention_keep_table
|
H A D | pg_partman--4.0.0--4.1.0.sql | 255 , retention_keep_table 280 , retention_keep_table 545 , retention_keep_table 573 , retention_keep_table 1058 , retention_keep_table = v_row.sub_retention_keep_table 1519 , retention_keep_table = v_row.sub_retention_keep_table
|
H A D | pg_partman--1.3.0--1.4.0.sql | 1620 , retention_keep_table 1642 , retention_keep_table 1822 , retention_keep_table 1844 , retention_keep_table
|
/dports/databases/pg_partman/pg_partman-4.5.1/sql/functions/ |
H A D | drop_partition_id.sql | 53 , retention_keep_table 78 , retention_keep_table
|
H A D | drop_partition_time.sql | 55 , retention_keep_table 83 , retention_keep_table
|
H A D | dump_partition_table_definition.sql | 52 pc.retention_keep_table,
|
H A D | create_partition_id.sql | 304 , retention_keep_table = v_row.sub_retention_keep_table
|
/dports/databases/pg_partman/pg_partman-4.5.1/sql/tables/ |
H A D | tables.sql | 14 , retention_keep_table boolean NOT NULL DEFAULT true field
|