From: Christophe Labouisse <labouiss@cybercable.fr>
To: pgsql-sql@postgresql.org
Subject: Integrity and Inheritance
Date: 10 Jun 2001 07:08:42 +0200
Message-ID: <m2hexo9b1h.fsf@gabuzo.meunet> (raw)
I wanted to build the following schema :
- one "generic" document table with a column doc_id ;
- a couple of "specific" document tables inheriting from doc ;
- a table refering a document by it's id with and integrity constraint
on it.
In SQL :
CREATE TABLE doc (
doc_id serial PRIMARY KEY,
);
CREATE TABLE lexique (
) INHERITS (doc);
CREATE TABLE word_doc (
id serial PRIMARY KEY,
doc_id int4 NOT NULL CONSTRAINT word_doc_doc_id_ref REFERENCES doc ON DELETE CASCADE,
);
What I tried to do next is to insert a new "lexique" entry, and then a
bunch of "word_doc" rows refering this entry. The last part fails with
a constraint violation this is quite normal since the trigger in
backend/utils/adt/ri_triggers.c makes a "SELECT FROM ONLY".
What should I do ? Should I consider another way to do what I want,
rewrite a trigger to replace the system one ?
--
Le cinéma en Lumière : http://www.lumiere.org/
Fingerprint : 4721 651D D309 B302 93E4 5D73 CC52 DF3A E7C7 86CF
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: labouiss@cybercable.fr
Subject: Re: Integrity and Inheritance
In-Reply-To: <m2hexo9b1h.fsf@gabuzo.meunet>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox