Sample Header Ad - 728x90

Problem with foreign key between 3 tables. (PgAdminIII)

1 vote
2 answers
380 views
I'm using pgAdmin III for PostgreSQL but I have a problem with foreign keys between 3 tables. My tables are: **Locale** with a **primary key IDnegozio** (integer type, no need to make it serial type) **Orario** with a **primary key IDorario** (integer type, no need to make it serial type) **OrarioToLocale** with two columns: **IDlocaleT** & **IDorarioT** (both integer). I'm trying to make a foreign key between IDlocale -> IDlocaleT and IDorario -> IDorarioT so, I can have the relation that a Shop can have multiples time. The problem is that when I try to make these foreign keys, and an error occurs me: "no unique constraint matching is given keys for referenced table" and I don't understand why. I tried to google but I didn't find any answer! How can I do? This is the code of the three tables: CREATE TABLE public."Locale" ( "IDnegozio" integer NOT NULL DEFAULT nextval('"Locale_IDnegozio_seq"'::regclass), CONSTRAINT "Locale_pkey" PRIMARY KEY ("IDnegozio"), ) CREATE TABLE public."Orario" ( "IDorario" integer NOT NULL DEFAULT nextval('"Orario_IDorario_seq"'::regclass), CONSTRAINT "Orario_pkey" PRIMARY KEY ("IDorario") ) CREATE TABLE public."OrarioToLocale" ( "IDlocaleT" integer NOT NULL, "IDorarioT" integer NOT NULL ) How can I do? Thank you advice!
Asked by JEricaM (113 rep)
May 17, 2017, 07:26 AM
Last activity: May 17, 2017, 10:55 AM