| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | Renaud Thonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: table inheritance |
| Date: | 2001-06-10 01:24:46 |
| Message-ID: | 200106100124.f5A1OkI14725@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Thu, 31 May 2001, Renaud Thonnart wrote:
>
> > Hi all!
> >
> > I would like to know if a table that inherits an other does also inherit
> > of the constraints,triggers,... of the parent table because it is not
> > mentioned in the PostgreSQL guide.
>
> AFAIK, Not null and Check constraints are inherited. Unique, Primary Key,
> Foreign Key and user triggers are not.
TODO updated:
* Allow inherited tables to inherit index, UNIQUE constraint, and
primary key, foreign key [inheritance]
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-10 01:27:10 | Re: Functionality |
| Previous Message | Tim Mickol | 2001-06-10 00:53:07 | PGDG? |