Postgres Pro
Downloads
Home   >   mailing lists

Thread: referential integrity

referential integrity

From
"Michelle Anderson"
Date:

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

Re: referential integrity

From
"Oliver Elphick"
Date:
"Michelle Anderson" wrote:
  >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.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
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