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
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.
Thanks for your help Stephan !
Renaud
Stephan Szabo wrote:
Show quoted text
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