Thread: table inheritance

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.

Thank you.

Sincerely,
Renaud THONNART

Thanks for your help Stephan !
Renaud

Stephan Szabo wrote:

> 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.

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.

> 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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026