File tree Expand file tree Collapse file tree 2 files changed +8
-2
lines changed Expand file tree Collapse file tree 2 files changed +8
-2
lines changed Original file line number Diff line number Diff line change @@ -157,9 +157,12 @@ SELECT * FROM copy_stmt_hooking.test WHERE val > 20;
157
157
21 | test_no_part | 0 | 0
158
158
(1 row)
159
159
160
- /* COPY TO (partitioned column is not specified) */
160
+ /* COPY FROM (partitioned column is not specified) */
161
161
COPY copy_stmt_hooking.test(comment) FROM stdin;
162
162
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
163
166
/* Drop column (make use of 'tuple_map') */
164
167
ALTER TABLE copy_stmt_hooking.test DROP COLUMN comment;
165
168
/* create new partition */
Original file line number Diff line number Diff line change @@ -70,11 +70,14 @@ COPY copy_stmt_hooking.test FROM stdin;
70
70
\.
71
71
SELECT * FROM copy_stmt_hooking .test WHERE val > 20 ;
72
72
73
- /* COPY TO (partitioned column is not specified) */
73
+ /* COPY FROM (partitioned column is not specified) */
74
74
COPY copy_stmt_hooking .test (comment) FROM stdin;
75
75
test_no_part
76
76
\.
77
77
78
+ /* COPY FROM (we don't support FREEZE) */
79
+ COPY copy_stmt_hooking .test FROM stdin WITH (FREEZE);
80
+
78
81
79
82
/* Drop column (make use of 'tuple_map') */
80
83
ALTER TABLE copy_stmt_hooking .test DROP COLUMN comment;
You can’t perform that action at this time.
0 commit comments