Re: Referential Integrity problem

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: James Gregory <james(at)anchor(dot)net(dot)au>
Cc: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Referential Integrity problem
Date: 2003-03-19 00:08:04
Message-ID: 20030318160621.X45066-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 19 Mar 2003, James Gregory wrote:

> I hope this one is just some misunderstanding on my part.

Referential integrity constraints currently apply only to the explicitly
named table. In addition, the saleable_item primary key on id is not
inherited by product (and so there can be duplicates in product - even if
you put a unique constraint on product(id), you still can have duplicates
between saleable_item and product).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2003-03-19 00:21:43 Limitations in PL/perl
Previous Message Wayne Armstrong 2003-03-18 22:27:09 Re: insert aliases?