Re: Dropping a column on parent table doesn't propagate to children?

On Wed, Aug 29, 2012 at 12:11 PM, Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>wrote:

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

I don't see the answers to #1 and #2 there...

--
Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe(at)neadwerx(dot)com | www.neadwerx.com