From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dutt Kalapatapu <dutt@eudoramail.com>
Cc: pgsql-interfaces@postgreSQL.org
Cc: pgsql-sql@postgreSQL.org
Cc: dutt@pacbell.net
Subject: Re: [SQL] Question on Inheritance and Primary Keys.
Date: Mon, 11 Oct 1999 21:21:02 -0400
Message-ID: <10277.939691262@sss.pgh.pa.us> (raw)
In-Reply-To: <3.0.6.32.19991011122638.009aa3e0@pop.eudoramail.com>
Dutt Kalapatapu <dutt@eudoramail.com> writes:
> I expect from this that when we insert some thing in TableB then
> parameterone should be unique, but the database is not enforcing the rule
> and it takes duplicate values.
Constraints and indexes aren't inherited; you have to redeclare them for
each derived table. I agree this is a bug, or at least lack of a
feature that ought to be there. It's on the TODO list, in fact:
* Unique index on base column not honored on inserts from inherited table
INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail
[inherit]
I don't know when it might get fixed. None of the currently active
developers seem to be very interested in inheritance issues, so it
could be a while before anyone decides to look at this problem.
regards, tom lane
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-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, dutt@eudoramail.com, pgsql-sql@postgreSQL.org, dutt@pacbell.net
Subject: Re: [SQL] Question on Inheritance and Primary Keys.
In-Reply-To: <10277.939691262@sss.pgh.pa.us>
* 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