PROBLEM WITH FOREIGN KEY - Mailing list pgsql-admin

From Mario Alberto Soto Cordones
Subject PROBLEM WITH FOREIGN KEY
Date
Msg-id 2132.192.168.1.100.1048005174.squirrel@www.compuall.cl
Whole thread Raw
List pgsql-admin
hi.

i have a big problem...

i have created a 2 table cumacar and cumaasi,

the structure is

CUMACAR

cuidcar   char(2)
cucodcar  numeric(2)
cudescar  varchar(35)
cuempcar  numeric(2)
primary key (cucodcar, cuempcar)


CUMAASI

cucodasi  numeric  3
cudesasi  varchar  60
cucarasi  numeric  2
cuempasi  numeric  2
primary key (cucarasi, cucodasi, cuempasi)

i try create a foreing key and say:

Error - /var/www/html/phpPgAdmin/sql.php -- Line: 112
PostgreSQL ha dicho: ERROR: cumaasi_fk_cumacar referential integrity
violation - key referenced from cumaasi not found in cumacar
Your query:
ALTER TABLE cumaasi
ADD CONSTRAINT cumaasi_fk_cumacar
FOREIGN KEY(cucarasi, cuempasi)
REFERENCES
cumacar (cucodcar, cuempcar)


PLEASE HELP ME

sorry for my englis... i live in chile...

thank you











pgsql-admin by date:

Previous
From: Nicolas Boretos
Date:
Subject: Re: pgaccess on windows
Next
From: "Donald Fraser"
Date:
Subject: Re: PROBLEM WITH FOREIGN KEY