All pastes #794128 Raw Edit

Someone

public text v1 · immutable
·published 2007-11-22 22:14 UTC
rendered paste body
Table "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')