referential integrity

From: "Michelle Anderson" <andersom(at)nortelnetworks(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: referential integrity
Date: 2001-01-16 13:55:11
Message-ID: DB5C82C00827D211971F0000F8EF7D7E015C509C@zired000.europe.nortel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message jeremy ergisi 2001-01-16 15:48:14 how read a text file in PG ???
Previous Message Mirko Zeibig 2001-01-16 11:58:41 Re: Spot the error in my plpgsql...