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

Commitb718cbd

Browse files
committed
migration script from 1.2 to 1.3
1 parent369b49d commitb718cbd

File tree

4 files changed

+916
-53
lines changed

4 files changed

+916
-53
lines changed

‎.gitignore

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -9,4 +9,4 @@ regression.out
99
*.gcda
1010
*.gcno
1111
*.gcov
12-
pg_pathman--*.sql
12+
pg_pathman--1.3.sql

‎init.sql

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -251,7 +251,7 @@ LANGUAGE plpgsql;
251251
CREATEOR REPLACE FUNCTION @extschema@.show_partition_list()
252252
RETURNS TABLE (
253253
parentREGCLASS,
254-
"partition"REGCLASS,
254+
partitionREGCLASS,
255255
parttypeINT4,
256256
partattrTEXT,
257257
range_minTEXT,
@@ -643,21 +643,21 @@ SET pg_pathman.enable_partitionfilter = off; /* ensures that PartitionFilter is
643643
*/
644644
CREATEOR REPLACE FUNCTION @extschema@.copy_foreign_keys(
645645
parent_relidREGCLASS,
646-
partition_relidREGCLASS)
646+
partitionREGCLASS)
647647
RETURNS VOIDAS
648648
$$
649649
DECLARE
650650
recRECORD;
651651

652652
BEGIN
653653
PERFORM @extschema@.validate_relname(parent_relid);
654-
PERFORM @extschema@.validate_relname(partition_relid);
654+
PERFORM @extschema@.validate_relname(partition);
655655

656656
FOR recIN (SELECToidas conidFROMpg_catalog.pg_constraint
657657
WHERE conrelid= parent_relidAND contype='f')
658658
LOOP
659659
EXECUTE format('ALTER TABLE %s ADD %s',
660-
partition_relid::TEXT,
660+
partition::TEXT,
661661
pg_catalog.pg_get_constraintdef(rec.conid));
662662
END LOOP;
663663
END
@@ -880,7 +880,7 @@ LANGUAGE C STRICT;
880880
*/
881881
CREATEOR REPLACE FUNCTION @extschema@.invoke_on_partition_created_callback(
882882
parent_relidREGCLASS,
883-
"partition"REGCLASS,
883+
partitionREGCLASS,
884884
init_callbackREGPROCEDURE,
885885
start_valueANYELEMENT,
886886
end_valueANYELEMENT)
@@ -892,7 +892,7 @@ LANGUAGE C;
892892
*/
893893
CREATEOR REPLACE FUNCTION @extschema@.invoke_on_partition_created_callback(
894894
parent_relidREGCLASS,
895-
"partition"REGCLASS,
895+
partitionREGCLASS,
896896
init_callbackREGPROCEDURE)
897897
RETURNS VOIDAS'pg_pathman','invoke_on_partition_created_callback'
898898
LANGUAGE C;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp