Very Computer

by **Michelle Anderso** » Fri, 19 Jan 2001 23:39:56

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07FC3.F1525930
Content-Type: text/plain; charset="iso-8859-1"

Please could someone help me my database does not have referential
integrity. I want to be able to delete a primary key in one table and for
it to delete anything relating to it below ( same with update).

i.e table product primary key product_name

table release primary key release_id
product_name field references product_name in
product table
I get a message to screen that says

NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented

thanks in advance for any help whatsoever.

Michelle Anderson

------_=_NextPart_001_01C07FC3.F1525930
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2652.35">
<TITLE>referential integrity </TITLE>
</HEAD>
<BODY>

Please could someone help me my database d=
oes not have referential integrity.  I want to be able to delete a pri=
mary key in one table and for it to delete anything relating to it below ( =
same with update).

i.e table product    &=
nbsp;          primary key product_=
name

table release&nbs=
p;             prima=
ry key release_id  
             &nbs=
p;           product_name field references product_name in product table</F=
ONT>
 I get a message to screen that says </FON=
T>

NOTICE:  CREATE TABLE/FOREIGN KEY cla=
use ignored; not yet implemented
             &nbs=
p;  =20
 thanks in advance for any<B=

Quote:> help whatsoever.

Michelle Anderson</FON=
T>

</BODY>
</HTML>
------_=_NextPart_001_01C07FC3.F1525930--

by **Oliver Elphic** » Sat, 20 Jan 2001 02:04:01

>I get a message to screen that says
>
>NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented

You need to upgrade to PostgreSQL 7.0.3; referential inegrity is not
implemented in 6.5.3 and earlier.

--

Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"For the eyes of the LORD run to and fro throughout the
whole earth, to show himself strong in the behalf of
them whose heart is perfect toward him..."
II Chronicles 16:9