referential integrity

referential integrity

Post 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>

<P><FONT SIZE=3D2 FACE=3D"Arial">Please could someone help me my database d=
oes not have referential integrity.&nbsp; 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).</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">i.e table product&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; primary key product_=
name</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp; table release&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prima=
ry key release_id&nbsp; </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 FA=
CE=3D"Arial">product_name field references product_name in product table</F=
ONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I get a message to screen that says </FON=
T>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">NOTICE:&nbsp; CREATE TABLE/FOREIGN KEY cla=
use ignored; not yet implemented</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;=20
<BR><FONT SIZE=3D2 FACE=3D"Arial">thanks in advance for<U><B> any</B></U><B=

Quote:></B> help whatsoever.</FONT>

</P>

<P><B><FONT COLOR=3D"#FF0000" FACE=3D"Comic Sans MS">Michelle Anderson</FON=
T></B>
</P>
<BR>

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

 
 
 

referential integrity

Post 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