From: Neal Lindsay <neal.lindsay@peaofohio.com>
To: pgsql-sql@postgresql.org
Subject: Re: Inheritence and Integrity
Date: Wed, 29 Jan 2003 15:39:49 -0500
Message-ID: <b19e6o$iic$1@news.hub.org> (raw)
In-Reply-To: <20030129121750.N14196-100000@megazone23.bigpanda.com>
References: <20030129121750.N14196-100000@megazone23.bigpanda.com>
Stephan Szabo wrote:
> On Wed, 29 Jan 2003, Neal Lindsay wrote:
>>I am creating a database that will keep track of several different types
>>of 'events'. I am toying with the idea of making a base 'class' table
>>for the tables because a lot of the information will be the same (also
>>there will probably be times I just need to get the basic information
>>about events regardless of their type). My question is: will triggers
>>and rules on the parent table fire when I insert data in the child
>>tables? Are there any other potential pitfalls?
>
>
> Currently that won't do what you want because triggers are not inherited
> and the constraint is set up so the references constraint ends up being
> only on the rows in parenttable. In addition, the primary key constraint
> won't do what you probably want either, although since it's a serial, you
> won't be likely to notice.
>
So what you're saying is that I could insert a duplicate primary key
into the parent table by inserting an explicit value in that field in my
child table? And if I leave that column out of my insert statement the
"default nextval()" will still make it a unique value?
If that is so, is there a way to make constraint that will keep primary
keys unique across all the child tables of my parent table?
-Neal Lindsay
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: neal.lindsay@peaofohio.com
Subject: Re: Inheritence and Integrity
In-Reply-To: <b19e6o$iic$1@news.hub.org>
* 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