Closed znmeb closed 6 years ago
Done - it turns out that crash_id, partic_idand vhcl_id worked as primary keys in PostgreSQL. I don't know what the problem was last night. The code is
crash_id
partic_id
vhcl_id
"ALTER TABLE public.crash ADD CONSTRAINT crash_pkey PRIMARY KEY (crash_id);" "ALTER TABLE public.partic ADD CONSTRAINT partic_pkey PRIMARY KEY (partic_id);" "ALTER TABLE public.vhcl ADD CONSTRAINT vhcl_pkey PRIMARY KEY (vhcl_id);"
Done - it turns out that
crash_id,partic_idandvhcl_idworked as primary keys in PostgreSQL. I don't know what the problem was last night. The code is