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

Commit15e574e

Browse files
committed
test FREEZE in pathman_utility_stmt_hooking
1 parent176572e commit15e574e

File tree

2 files changed

+8
-2
lines changed

2 files changed

+8
-2
lines changed

‎expected/pathman_utility_stmt_hooking.out‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -157,9 +157,12 @@ SELECT * FROM copy_stmt_hooking.test WHERE val > 20;
157157
21 | test_no_part | 0 | 0
158158
(1 row)
159159

160-
/* COPYTO (partitioned column is not specified) */
160+
/* COPYFROM (partitioned column is not specified) */
161161
COPY copy_stmt_hooking.test(comment) FROM stdin;
162162
ERROR: partitioned column's value should not be NULL
163+
/* COPY FROM (we don't support FREEZE) */
164+
COPY copy_stmt_hooking.test FROM stdin WITH (FREEZE);
165+
ERROR: freeze is not supported for partitioned tables
163166
/* Drop column (make use of 'tuple_map') */
164167
ALTER TABLE copy_stmt_hooking.test DROP COLUMN comment;
165168
/* create new partition */

‎sql/pathman_utility_stmt_hooking.sql‎

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -70,11 +70,14 @@ COPY copy_stmt_hooking.test FROM stdin;
7070
\.
7171
SELECT*FROMcopy_stmt_hooking.testWHERE val>20;
7272

73-
/* COPYTO (partitioned column is not specified)*/
73+
/* COPYFROM (partitioned column is not specified)*/
7474
COPYcopy_stmt_hooking.test(comment)FROM stdin;
7575
test_no_part
7676
\.
7777

78+
/* COPY FROM (we don't support FREEZE)*/
79+
COPYcopy_stmt_hooking.testFROM stdin WITH (FREEZE);
80+
7881

7982
/* Drop column (make use of 'tuple_map')*/
8083
ALTERTABLEcopy_stmt_hooking.test DROP COLUMN comment;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp