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

Perfect response, thank you Sergey.

On Thu, Aug 30, 2012 at 7:29 AM, Sergey Konoplev <
sergey(dot)konoplev(at)postgresql-consulting(dot)com> wrote:

> On Wed, Aug 29, 2012 at 5:48 PM, Moshe Jacobson <moshe(at)neadwerx(dot)com>
> wrote:
> > 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?
>
> You must. Indexes are not inheritable.
>
> > 2. If I move the inherited table to a new schema, will its indexes also
> be
> > moved into the new schema?
>
> They will be.
>
> > 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>"?
>
> AIU you mean pure inheritance vs inheritance + pure LIKE. In this case
> I do not see any.
>
> >> > Also, another question about the docs. The syntax for the ALTER TABLE
> >> > command starts as follows:
> >> >
> >> > ALTER TABLE [ ONLY ] name [ * ]
> >> >
> >> > What is the asterisk? It is not explained anywhere on that page.
>
> As I was told in IRC:
>
> RhodiumToad: grayhemp: opposite of ONLY, only present for historical
> reasons since it's the default and has been for decades
>
> so nothing important.
>
> >> >
> >> > Thanks,
> >> > Moshe
> >> >
> >> > --
> >> > Moshe Jacobson
> >> > Nead Werx, Inc. | Senior Systems Engineer
> >> > 2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
> >> > moshe(at)neadwerx(dot)com | www.neadwerx.com
> >> >
> >>
> >> --
> >> Sergey Konoplev
> >>
> >> a database architect, software developer at PostgreSQL-Consulting.com
> >> http://www.postgresql-consulting.com
> >>
> >> Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204
> >
> >
> >
> >
> > --
> > Moshe Jacobson
> > Nead Werx, Inc. | Senior Systems Engineer
> > 2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
> > moshe(at)neadwerx(dot)com | www.neadwerx.com
> >
>
>
>
> --
> Sergey Konoplev
>
> a database architect, software developer at PostgreSQL-Consulting.com
> http://www.postgresql-consulting.com
>
> Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204
>

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