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

Commit8918bd3

Browse files
committed
Make few fixes in tests added by1817d26
1 parent1817d26 commit8918bd3

File tree

2 files changed

+2
-3
lines changed

2 files changed

+2
-3
lines changed

‎expected/pathman_dropped_cols.out

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -112,8 +112,6 @@ ALTER TABLE root_dict ADD COLUMN dict_id BIGINT DEFAULT 3;
112112
ALTER TABLE root_dict DROP COLUMN dict_code,
113113
DROP COLUMN dict_name,
114114
DROP COLUMN sign;
115-
CREATE EXTENSION pg_pathman;
116-
ERROR: extension "pg_pathman" already exists
117115
SELECT create_hash_partitions('root_dict' :: REGCLASS,
118116
'root_id',
119117
3,
@@ -204,6 +202,7 @@ EXPLAIN EXECUTE getbyroot(2);
204202
Index Cond: (root_id = $1)
205203
(14 rows)
206204

205+
DEALLOCATE getbyroot;
207206
DROP TABLE root_dict CASCADE;
208207
NOTICE: drop cascades to 3 other objects
209208
DROP SCHEMA dropped_cols CASCADE;

‎sql/pathman_dropped_cols.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -74,7 +74,6 @@ ALTER TABLE root_dict DROP COLUMN dict_code,
7474
DROP COLUMN dict_name,
7575
DROP COLUMN sign;
7676

77-
CREATE EXTENSION pg_pathman;
7877
SELECT create_hash_partitions('root_dict' :: REGCLASS,
7978
'root_id',
8079
3,
@@ -99,6 +98,7 @@ EXECUTE getbyroot(2);
9998
EXECUTE getbyroot(2);
10099
EXPLAIN EXECUTE getbyroot(2);
101100

101+
DEALLOCATE getbyroot;
102102
DROPTABLE root_dict CASCADE;
103103
DROPSCHEMA dropped_cols CASCADE;
104104
DROP EXTENSION pg_pathman;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp