|
6 | 6 | -- BTREE
|
7 | 7 | --
|
8 | 8 | CREATE INDEX onek_unique1 ON onek USING btree(unique1 int4_ops);
|
| 9 | +CREATE INDEX IF NOT EXISTS onek_unique1 ON onek USING btree(unique1 int4_ops); |
| 10 | +NOTICE: relation "onek_unique1" already exists, skipping |
| 11 | +CREATE INDEX IF NOT EXISTS ON onek USING btree(unique1 int4_ops); |
| 12 | +ERROR: syntax error at or near "ON" |
| 13 | +LINE 1: CREATE INDEX IF NOT EXISTS ON onek USING btree(unique1 int4_... |
| 14 | + ^ |
9 | 15 | CREATE INDEX onek_unique2 ON onek USING btree(unique2 int4_ops);
|
10 | 16 | CREATE INDEX onek_hundred ON onek USING btree(hundred int4_ops);
|
11 | 17 | CREATE INDEX onek_stringu1 ON onek USING btree(stringu1 name_ops);
|
@@ -2290,10 +2296,14 @@ create unique index hash_f8_index_3 on hash_f8_heap(random) where seqno > 1000;
|
2290 | 2296 | CREATE TABLE concur_heap (f1 text, f2 text);
|
2291 | 2297 | -- empty table
|
2292 | 2298 | CREATE INDEX CONCURRENTLY concur_index1 ON concur_heap(f2,f1);
|
| 2299 | +CREATE INDEX CONCURRENTLY IF NOT EXISTS concur_index1 ON concur_heap(f2,f1); |
| 2300 | +NOTICE: relation "concur_index1" already exists, skipping |
2293 | 2301 | INSERT INTO concur_heap VALUES ('a','b');
|
2294 | 2302 | INSERT INTO concur_heap VALUES ('b','b');
|
2295 | 2303 | -- unique index
|
2296 | 2304 | CREATE UNIQUE INDEX CONCURRENTLY concur_index2 ON concur_heap(f1);
|
| 2305 | +CREATE UNIQUE INDEX CONCURRENTLY IF NOT EXISTS concur_index2 ON concur_heap(f1); |
| 2306 | +NOTICE: relation "concur_index2" already exists, skipping |
2297 | 2307 | -- check if constraint is set up properly to be enforced
|
2298 | 2308 | INSERT INTO concur_heap VALUES ('b','x');
|
2299 | 2309 | ERROR: duplicate key value violates unique constraint "concur_index2"
|
|
0 commit comments