1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
---
--- Index creation fails when referencing an object due to search_path issues
---
--- See https://github.com/dimitri/pgcopydb/issues/489
BEGIN;
CREATE SCHEMA """abc""";
CREATE TYPE """abc""".state AS ENUM (
'PROPOSED',
'SCHEDULED',
'STARTED'
);
CREATE TABLE """abc""".job (
id bigint NOT NULL,
state """abc""".state DEFAULT 'SCHEDULED'::"""abc""".state NOT NULL,
date date NOT NULL
);
CREATE INDEX indexname ON """abc""".job USING btree (state) WHERE (state = 'SCHEDULED'::state);
COMMIT;
|
