On Wed, Mar 30, 2005 at 02:09:05PM +0200, [EMAIL PROTECTED] wrote: > > Thanks for your answers but i make the modifications, the same error returned. > Here my script : > ... > Create table Salari�s (Nom_salari� VARCHAR(20), > Pr�nom VARCHAR(20), > Fonction VARCHAR(50), > Service VARCHAR(50), > Adresse VARCHAR(100), > Numero_SS integer, > Matricule VARCHAR(6), > rs_ssii VARCHAR(30) references ssii, > PRIMARY KEY ( Nom_salari�, rs_ssii)) ;
The salari�s table has a primary key with two columns. > Create table Compteur (id integer, > Heures_travaill�es decimal(6,2), > Cp_acquis decimal(6,2), > Cp_pris decimal(6,2), > RTT_acquis decimal(6,2), > RTT_pris decimal(6,2), > Nom_salari� VARCHAR(20) references salari�s, > rs_ssii VARCHAR(30) references ssii, > PRIMARY KEY ( Nom_salari�,rs_ssii,Id)) ; The foreign key reference to salari�s has only one column but the primary key for salari�s has two columns, hence the error. It looks like you should be doing this: Nom_salari� VARCHAR(20), rs_ssii VARCHAR(30), FOREIGN KEY (Nom_salari�, rs_ssii) REFERENCES salari�s, -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
