Re: Foreign key problem in Postgresql-7.2

On Mon, 20 May 2002, Thirumoorthy Bhuvneswari wrote:

> hi,
> I am using Postgresql-7.1.3 with Redhat Linux-7.1 for
> my application developed in Java. I have created some
> tables with foreign keys which are not the primary
> keys in the master tables. Its working fine in
> Linux-7.1.3. I tried to upgrade my system with
> Postgresql-7.2 and did restore of my database. It did
> not accept such foreign keys. Though the design may
> not be of its best normalization form, I use such
> foreign keys for ease of maintenance. How can I get
> them in Postgresql-7.2. Thanks in advance.
>
> bhuvana.

Hi,

ALTER TABLE table_name ADD CONSTRAINT const_name FOREIGN KEY (Column_Name)
REFERENCES ref_table_name(ref_column_name) ;

Should do the trick.

--
Regards,

Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk