Postgres Pro
Downloads
Home   >   mailing lists

Adding Foreign Key Constraint To Existing Table - Mailing list pgsql-general

From Rich Shepard
Subject Adding Foreign Key Constraint To Existing Table
Date
Msg-id alpine.LNX.2.00.1107011357390.31349@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Adding Foreign Key Constraint To Existing Table  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Adding Foreign Key Constraint To Existing Table  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Adding Foreign Key Constraint To Existing Table  (Thom Brown <thom@linux.com>)
Re: Adding Foreign Key Constraint To Existing Table  (Thom Brown <thom@linux.com>)
Re: Adding Foreign Key Constraint To Existing Table  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
   I've examined the 9.0 manual page on alter table without seeing how to add
a foreign key constraint to a column.

   I needed to make changes on a couple of existing tables which could be
accomplished only by dropping the foreign key constraint. That, and changing
the table structure, column names, and column types were successful. But, I
am not seeing the proper syntax to add a foreign key constraint back to the
two affected tables.

   Pointer please.

Rich

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: pg_upgrade does not translate tablespace location to new cluster
Next
From: Adrian Klaver
Date:
Subject: Re: Adding Foreign Key Constraint To Existing Table