Skip site navigation (1) Skip section navigation (2)

Re: ALTER TABLE ADD CONSTRAINT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: José Roberto Motta Garcia <garcia(at)cptec(dot)inpe(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ALTER TABLE ADD CONSTRAINT
Date: 2007-07-19 21:48:41
Message-ID: 9757.1184881721@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
=?ISO-8859-1?Q?Jos=E9_Roberto_Motta_Garcia?= <garcia(at)cptec(dot)inpe(dot)br> 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
> estacoes (id_estacao, id_estacao)

I can't reproduce any such misbehavior here.  What PG version is this
exactly?  What are you doing to "check the DDL"?

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Christoph HeiblDate: 2007-07-20 12:19:31
Subject: deinstallation - reinstallation on Mac OS 10.4
Previous:From: José Roberto Motta GarciaDate: 2007-07-19 17:58:49
Subject: ALTER TABLE ADD CONSTRAINT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group