Le mercredi 29 août 2012 à 09:48 -0400, Moshe Jacobson a écrit :
>
>
> Questions:
> 1. If I want the inherited table's columns indexed the same way as the
> parent, must I create new indexes on the inherited table?
> 2. If I move the inherited table to a new schema, will its indexes
> also be moved into the new schema?
> 3. Any difference in behavior regarding check constraints, schemas,
> indexes, etc that I should be aware of between inherited tables
> created with pure inheritance as opposed to "like <parent_table>"?
>
The 'LIKE' section of the documentation for CREATE TABLE explains it :
http://www.postgresql.org/docs/9.1/static/sql-createtable.html
--
Vincent Veyron
http://marica.fr/
Gestion informatique des sinistres d'assurances et des dossiers contentieux pour le service juridique