Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit581a695

Browse files
committed
fix migration script (broken DROP TRIGGER, after-update-instruction)
1 parente31e4b5 commit581a695

File tree

1 file changed

+12
-1
lines changed

1 file changed

+12
-1
lines changed

‎pg_pathman--1.1--1.2.sql

Lines changed: 12 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -26,7 +26,7 @@ DROP FUNCTION @extschema@.split_range_partition(REGCLASS, ANYELEMENT, TEXT, OUT
2626
DROPFUNCTION @extschema@.invalidate_relcache(OID);
2727

2828
/* drop trigger and its function (PATHMAN_CONFIG_PARAMS)*/
29-
DROPTRIGGER pathman_config_params_trigger;
29+
DROPTRIGGER pathman_config_params_triggerON @extschema@.pathman_config_params;
3030
DROPFUNCTION @extschema@.pathman_config_params_trigger_func();
3131

3232

@@ -1291,3 +1291,14 @@ LANGUAGE C STRICT;
12911291
* ----------------------------------------------------------------------*/
12921292
ALTERTABLE @extschema@.pathman_config_params ADD COLUMN spawn_using_bgwBOOLEANNOT NULL DEFAULT FALSE;
12931293
ALTERTABLE @extschema@.pathman_config_params ADDCHECK (@extschema@.validate_part_callback(init_callback));
1294+
1295+
1296+
/* ------------------------------------------------------------------------
1297+
* Final words of wisdom
1298+
* ----------------------------------------------------------------------*/
1299+
DO language plpgsql
1300+
$$
1301+
BEGIN
1302+
RAISE WARNING'Don''t forget to execute "SET pg_pathman.enable = t" to activate pg_pathman';
1303+
END
1304+
$$;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp