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

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
Cc: 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 19:39:27
Message-ID: CAJ4CxL=qYFB=WJjk4DBETdKGtgj_Pv+wuc=v4=O6BzUGWfYAVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

> #1
> Quote :
>
> Any indexes on the original table will not be created on the new table,
> unless the INCLUDING INDEXES clause is specified.
>

This is referring to the behavior on creating a table LIKE another table. I
am specifically asking about NOT using LIKE but just INHERITS.

> #2
>
I don't use schemas personnally, but if you do, I suggest you test and
> see what happens
>

I will.

Also, do you or does anyone know what the asterisk is for, that I asked
about at the end of my original post?

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Little, Douglas 2012-08-29 20:00:29 Re: psql & unix env variables
Previous Message Merlin Moncure 2012-08-29 19:22:15 Re: Views versus user-defined functions: formatting, comments, performance, etc.