Postgres Pro
Downloads
Home   >   mailing lists

Re: Dropping a column on parent table doesn't propagate to children? - Mailing list pgsql-general

From Moshe Jacobson
Subject Re: Dropping a column on parent table doesn't propagate to children?
Date
Msg-id CAJ4CxL=qYFB=WJjk4DBETdKGtgj_Pv+wuc=v4=O6BzUGWfYAVQ@mail.gmail.com
Whole thread Raw
In response to Re: Dropping a column on parent table doesn't propagate to children?  (Vincent Veyron <vv.lists@wanadoo.fr>)
List pgsql-general
Tree view
On Wed, Aug 29, 2012 at 3:06 PM, Vincent Veyron <vv.lists@wanadoo.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@neadwerx.com | www.neadwerx.com

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Views versus user-defined functions: formatting, comments, performance, etc.
Next
From: "Little, Douglas"
Date:
Subject: Re: psql & unix env variables