On Wed, Aug 29, 2012 at 5:48 PM, Moshe Jacobson <moshe@xxxxxxxxxxxx> 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@xxxxxxxxxxxx | www.neadwerx.com >> > >> >> -- >> Sergey Konoplev >> >> a database architect, software developer at PostgreSQL-Consulting.com >> http://www.postgresql-consulting.com >> >> Jabber: gray.ru@xxxxxxxxx Skype: gray-hemp Phone: +79160686204 > > > > > -- > Moshe Jacobson > Nead Werx, Inc. | Senior Systems Engineer > 2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339 > moshe@xxxxxxxxxxxx | www.neadwerx.com > -- Sergey Konoplev a database architect, software developer at PostgreSQL-Consulting.com http://www.postgresql-consulting.com Jabber: gray.ru@xxxxxxxxx Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
