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