rendered paste bodyTable "public.arc"
Column | Type | Modifiers
-------------+--------+-----------
from_siteid | bigint |
to_siteid | bigint |
Indexes:
"fromto-unique" UNIQUE, btree (from_siteid, to_siteid)
--
-- Data for Name: arc; Type: TABLE DATA; Schema: public; Owner: crawler
--
COPY arc (from_siteid, to_siteid) FROM stdin;
1 2
1 3
1 4
1 5
1 6
1 1
1 7
1 8
1 9
1 10
1 11
1 12
1 13
1 14
\.
--
-- PostgreSQL database dump complete
--
Inserting 1,1 causes the following error:
SQL error:
ERROR: duplicate key violates unique constraint "fromto-unique"
In statement:
INSERT INTO "arc" ("from_siteid", "to_siteid") VALUES ('1', '1')