unique constraint
| От | Dominique Bessette - Halsema |
|---|---|
| Тема | unique constraint |
| Дата | |
| Msg-id | b713ca6c0801241036i6c9ea680t21f0ba4e995db735@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: unique constraint
(Erik Jones <erik@myemma.com>)
|
| Список | pgsql-general |
STATEMENT: INSERT INTO "public"."tracks" ("guid","classification","creationtimestamp","lastupdatetime","effectivetime","reportedtime","staletime","confidencevalue","behavioridentity","nationality","classificationcategory","classconfidencevalue","axislabels","uomlabels","aoumajaxis","aouminaxis","aouvalid","the_geom") VALUES ('OOSTZEE','U','2008-01-22T21:05: 15.366Z','2008-01-22T21:05:15.366Z','2008-01-22T21:05:15.366Z','2008-01-22T21:05:15.366Z','2008-01-22T21:05:15.366Z',1.0,'FRIEND','','SEA','1.0','Lat Long h','degree degree',9999999,9999999,'true',setSRID('00000000014029D8E757928E0D404B9C28CBD1244A'::geometry,4326))
ERROR: duplicate key violates unique constraint "tracks_guid_key"
Track=# \d tracks
Table "public.tracks"
Column | Type | Modifiers
------------------------+-------------------+------------------------------------------------------
sid | integer | not null default nextval('tracks_sid_seq'::regclass)
guid | character varying | not null
classification | character varying |
creationtimestamp | character varying |
lastupdatetime | character varying |
effectivetime | character varying |
reportedtime | character varying |
staletime | character varying |
confidencevalue | numeric |
behavioridentity | character varying |
nationality | character varying |
classificationcategory | character varying |
classconfidencevalue | character varying |
axislabels | character varying |
uomlabels | character varying |
aoumajaxis | numeric |
aouminaxis | numeric |
aouvalid | character varying |
the_geom | geometry |
Indexes:
"tracks_pkey" PRIMARY KEY, btree (sid)
"tracks_guid_key" UNIQUE, btree (guid)
"tracks_the_geom_gist" gist (the_geom)
Check constraints:
"enforce_geotype_the_geom" CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL)
"enforce_srid_the_geom" CHECK (srid(the_geom) = 4326)
В списке pgsql-general по дате отправления: