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

Commit171696f

Browse files
committed
don't use analyze before add_to_pathman_config()
1 parent89dcaef commit171696f

File tree

3 files changed

+0
-7
lines changed

3 files changed

+0
-7
lines changed

‎expected/pathman_permissions.out‎

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,6 @@ GRANT SELECT ON permissions.user1_table TO user2;
1919
/* Should fail (don't own parent) */
2020
SET ROLE user2;
2121
SELECT create_range_partitions('permissions.user1_table', 'id', 1, 10, 2);
22-
WARNING: skipping "user1_table" --- only table or database owner can analyze it
2322
ERROR: only the owner or superuser can change partitioning configuration of table "user1_table"
2423
/* Should be ok */
2524
SET ROLE user1;

‎hash.sql‎

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -27,7 +27,6 @@ BEGIN
2727
partition_data);
2828

2929
/* Insert new entry to pathman config*/
30-
EXECUTE format('ANALYZE %s', parent_relid);
3130
PERFORM @extschema@.add_to_pathman_config(parent_relid, expression);
3231

3332
/* Create partitions*/

‎range.sql‎

Lines changed: 0 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -134,7 +134,6 @@ BEGIN
134134
END IF;
135135

136136
/* Insert new entry to pathman config*/
137-
EXECUTE format('ANALYZE %s', parent_relid);
138137
PERFORM @extschema@.add_to_pathman_config(parent_relid, expression,
139138
p_interval::TEXT);
140139

@@ -234,7 +233,6 @@ BEGIN
234233
END IF;
235234

236235
/* Insert new entry to pathman config*/
237-
EXECUTE format('ANALYZE %s', parent_relid);
238236
PERFORM @extschema@.add_to_pathman_config(parent_relid, expression,
239237
p_interval::TEXT);
240238

@@ -299,7 +297,6 @@ BEGIN
299297
bounds[array_length(bounds,1)-1]);
300298

301299
/* Insert new entry to pathman config*/
302-
EXECUTE format('ANALYZE %s', parent_relid);
303300
PERFORM @extschema@.add_to_pathman_config(parent_relid, expression,NULL);
304301

305302
/* Create sequence for child partitions names*/
@@ -352,7 +349,6 @@ BEGIN
352349
end_value);
353350

354351
/* Insert new entry to pathman config*/
355-
EXECUTE format('ANALYZE %s', parent_relid);
356352
PERFORM @extschema@.add_to_pathman_config(parent_relid, expression,
357353
p_interval::TEXT);
358354

@@ -411,7 +407,6 @@ BEGIN
411407
end_value);
412408

413409
/* Insert new entry to pathman config*/
414-
EXECUTE format('ANALYZE %s', parent_relid);
415410
PERFORM @extschema@.add_to_pathman_config(parent_relid, expression,
416411
p_interval::TEXT);
417412

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp