| From: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
|---|---|
| To: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
| Cc: | Sergey Konoplev <sergey(dot)konoplev(at)postgresql-consulting(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Dropping a column on parent table doesn't propagate to children? |
| Date: | 2012-08-29 16:11:48 |
| Message-ID: | 1346256708.3584.7.camel@asus-1001PX.home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-08-29 16:45:15 | Re: String comparision in PostgreSQL |
| Previous Message | Chris Angelico | 2012-08-29 16:09:06 | Re: String comparision in PostgreSQL |