Home
last modified time | relevance | path

Searched refs:drop_partition_time (Results 1 – 25 of 64) sorted by relevance

123

/dports/databases/pg_partman/pg_partman-4.5.1/test/test_native/
H A Dtest-time-epoch-weekly-native.sql179 SELECT drop_partition_time('partman_test.time_taptest_table', '3 weeks', p_keep_table := false);
192 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-native-mixed-case.sql591 SELECT drop_partition_time('Partman_Test.Time_Taptest_Table', '3 days', p_keep_table := false);
596 SELECT drop_partition_time('Partman_Test.Time_Taptest_Table', p_retention_schema := 'Partman_Retent…
H A Dtest-time-daily-native.sql614 SELECT drop_partition_time('partman_test.time_taptest_table', '3 days', p_keep_table := false);
619 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-custom-100years-native.sql390 SELECT drop_partition_time('partman_test.time_taptest_table', '300 years', p_keep_table := false);
395 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-custom-30sec-native.sql655 SELECT drop_partition_time('partman_test.time_taptest_table', '90 secs', p_keep_table := false);
662 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
/dports/databases/pg_partman/pg_partman-4.5.1/test/
H A Dtest-time-epoch-milliseconds-weekly.sql164 SELECT drop_partition_time('partman_test.time_taptest_table', '3 weeks', p_keep_table := false);
177 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-epoch-weekly.sql163 SELECT drop_partition_time('partman_test.time_taptest_table', '3 weeks', p_keep_table := false);
176 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-start-partition.sql194 SELECT drop_partition_time('partman_test.time_taptest_table', '3 days', p_keep_table := false);
199 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-weekly-trunc.sql320 SELECT drop_partition_time('partman_test.time_taptest_table_123456789012345678901234567890123457890…
325 SELECT drop_partition_time('partman_test.time_taptest_table_123456789012345678901234567890123457890…
H A Dtest-time-yearly-trunc.sql376 SELECT drop_partition_time('partman_test.time_taptest_table_123456789012345678901234567890123456780…
381 SELECT drop_partition_time('partman_test.time_taptest_table_123456789012345678901234567890123456780…
H A Dtest-time-yearly.sql423 SELECT drop_partition_time('partman_test.time_taptest_table', '3 years', p_keep_table := false);
428 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-daily.sql539 SELECT drop_partition_time('partman_test.time_taptest_table', '3 days', p_keep_table := false);
544 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-half-hour-trunc.sql620 SELECT drop_partition_time('partman_test.time_taptest_table_123456789012345678901234567901234567890…
627 SELECT drop_partition_time('partman_test.time_taptest_table_123456789012345678901234567901234567890…
H A Dtest-time-quarter-hour.sql620 SELECT drop_partition_time('partman_test.time_taptest_table', '45 mins', p_keep_table := false);
627 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
/dports/databases/pg_partman/pg_partman-4.5.1/test/test_native/generated_col/
H A Dtest-time-daily-generated.sql191 SELECT drop_partition_time('partman_test.time_taptest_table', '3 days', p_keep_table := false);
196 SELECT drop_partition_time('partman_test.time_taptest_table', p_keep_table := false);
/dports/databases/pg_partman/pg_partman-4.5.1/updates/
H A Dpg_partman--1.8.5--1.8.6.sql232 v_drop_count := v_drop_count + @extschema@.drop_partition_time(v_row.parent_table);
237 v_drop_count := v_drop_count + @extschema@.drop_partition_time(v_row.parent_table);
H A Dpg_partman--2.2.0--2.2.1.sql318 v_drop_count := v_drop_count + @extschema@.drop_partition_time(v_row.parent_table);
323 v_drop_count := v_drop_count + @extschema@.drop_partition_time(v_row.parent_table);
H A Dpg_partman--1.8.7--1.8.8.sql339 v_drop_count := v_drop_count + @extschema@.drop_partition_time(v_row.parent_table);
344 v_drop_count := v_drop_count + @extschema@.drop_partition_time(v_row.parent_table);
H A Dpg_partman--1.2.0--1.3.0.sql41 DROP FUNCTION drop_partition_time(text, interval, boolean, boolean);
568 CREATE FUNCTION drop_partition_time(p_parent_table text, p_retention interval DEFAULT NULL, p_keep_… function
/dports/databases/pg_partman/pg_partman-4.5.1/test/test_no_search_path/
H A Dtest-time-daily_nosearchpath.sql540 SELECT partman.drop_partition_time('partman_test.time_taptest_table', '3 days', p_keep_table := fal…
545 SELECT partman.drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partma…
/dports/databases/pg_partman/pg_partman-4.5.1/test/test_custom_time/
H A Dtest-time-custom-100years-epoch.sql376 SELECT drop_partition_time('partman_test.time_taptest_table', '300 years', p_keep_table := false);
381 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-custom-100years.sql367 SELECT drop_partition_time('partman_test.time_taptest_table', '300 years', p_keep_table := false);
372 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
H A Dtest-time-custom-30sec.sql627 SELECT drop_partition_time('partman_test.time_taptest_table', '90 secs', p_keep_table := false);
634 SELECT drop_partition_time('partman_test.time_taptest_table', p_retention_schema := 'partman_retent…
/dports/databases/pg_partman/pg_partman-4.5.1/test/test_bgw/
H A Dtest-time-daily-bgw.sql223 SELECT drop_partition_time('partman_test.time_taptest_table', '3 days', p_keep_table := false);
/dports/databases/pg_partman/pg_partman-4.5.1/sql/functions/
H A Ddrop_partition_time.sql1 CREATE FUNCTION @extschema@.drop_partition_time(p_parent_table text, p_retention interval DEFAULT N… function

123