Обсуждение: referential integrity
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
"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