Hi all, I do it in table synop:
ALTER TABLE synop ADD CONSTRAINT estacoes_fk FOREIGN KEY (id_estacao) REFERENCES estacoes Then I check the DDL and it is like this: .... CONSTRAINT estacoes_fk FOREIGN KEY (id_estacao, id_estacao) REFERENCES estacoes (id_estacao, id_estacao) .... - Why id_estacao is duplicated???? - id_estacao is the only column in pk of estacoes. Tks -- Jose Roberto M. Garcia, MSc Systems Analist - Database Group Voice: (12) 3186-8405 -- http://www.cptec.inpe.br http://www.inpe.br ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster