Postgres Pro
Downloads
Home   >   mailing lists

Thread: Foreign key problem in Postgresql-7.2

Foreign key problem in Postgresql-7.2

From
Thirumoorthy Bhuvneswari
Date:
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.

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

Re: Foreign key problem in Postgresql-7.2

From
Stephan Szabo
Date:
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.

Well, the values do not necessarily need to be primary keys,
but they must be unique.  Even in 7.1.x, there was no
check done to guarantee that the values are unique,
but for non-unique referenced columns the results
would sometimes end up being incorrect.

Re: Foreign key problem in Postgresql-7.2

From
"Wm. G. Urquhart"
Date:
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