Re: INHERIT vs INHERITS

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jaime Casanova" <jaime(at)2ndquadrant(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: INHERIT vs INHERITS
Date: 2012-03-13 22:50:36
Message-ID: 4F5F88EC0200002500046286@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:

> Has anyone ever complained about the inconsistency (at least it
> seems that to me) of using INHERITS in CREATE TABLE and INHERIT in
> ALTER TABLE?

They make sense to me as an English speaker. CREATE TABLE more or
less has a *description* of the table to be created, while ALTER
TABLE contains *actions* to take. ADD COLUMN, DROP COLUMN, INHERIT.
They are sub-commands.

In normal conversation you might say "Jane rides the bus to work."
But if you want to change that, you might say "Jane, ride your
bicycle to work."

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Farina 2012-03-13 23:02:03 Re: pg_upgrade and statistics
Previous Message Josh Berkus 2012-03-13 22:44:20 Re: wal_buffers, redux