| From: | Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Inheritence and Integrity |
| Date: | 2003-01-29 19:56:10 |
| Message-ID: | b19bkt$5t9$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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?
Thank you,
-Neal Lindsay
P.S. Here is a simplified example of my schema:
CREATE TABLE parenttable (
recordid SERIAL PRIMARY KEY,
recordname text
);
CREATE TABLE childtablea (
afield int4
) INHERITS parenttable;
CREATE TABLE childtableb (
bfield text
) INHERITS parenttable;
CREATE TABLE extrainfo (
extrainfoid SERIAL PRIMARY KEY,
record_fkey int4 NOT NULL REFERENCES parenttable(recordid),
extrainfotext text
);
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-01-29 20:19:18 | Re: Inheritence and Integrity |
| Previous Message | Wei Weng | 2003-01-29 15:55:42 | Re: help: triggers |