Re: ADD/DROP INHERITS - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: ADD/DROP INHERITS
Date
Msg-id 2398.24.211.165.134.1149723791.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: ADD/DROP INHERITS  (Greg Stark <gsstark@mit.edu>)
Responses Re: ADD/DROP INHERITS  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark said:
> Greg Stark <gsstark@MIT.EDU> writes:
>
>> How does
>>
>> ALTER TABLE table INHERITS ADD parent
>> ALTER TABLE table INHERITS DROP parent
>>
>> sound?
>>
>> I'll admit it doesn't read very well but it doesn't necessitate
>> complicating other rules in gram.y
>
> Or alternatively if people want to keep English-like SQL style grammar:
>
> ALTER TABLE table INHERIT parent
> ALTER TABLE table NO INHERIT parent
>


That could work ... or maybe UNINHERIT would read better than NO INHERIT.

cheers

andrew




pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: ADD/DROP INHERITS
Next
From: Robert Treat
Date:
Subject: Re: [PATCHES] drop if exists remainder