Re: [ADMIN] ALTER TABLE ADD CONSTRAINT

2007-07-19 Thread Tom Lane
=?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <[EMAIL PROTECTED]> writes: > 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 > e

[ADMIN] ALTER TABLE ADD CONSTRAINT

2007-07-19 Thread José Roberto Motta Garcia
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_estac