· 9 years ago · Oct 26, 2016, 11:36 AM
1CREATE TABLE IF NOT EXISTS TEST_1 (
2ID SERIAL PRIMARY KEY,
3C1 BYTEA,
4C2 TEXT NOT NULL,
5C3 BOOLEAN NOT NULL DEFAULT FALSE,
6CONSTRAINT TEST_1_unique_idx UNIQUE(C1, C2)
7);
8
9create or replace view test as select * from test_1 with cascaded check
10option;
11
12insert into test (c1, c2, c3) values (decode('MTIzAAE=', 'base64'), 'text', true) on conflict (c1, c2) do update set c3=excluded.c3
13
14[0A000] ERROR: ON CONFLICT is not supported on table "test" used as a catalog table
15 Position: 83