Re: ADD/DROP INHERITS

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <gsstark(at)MIT(dot)EDU>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ADD/DROP INHERITS
Date: 2006-06-07 23:43:11
Message-ID: 2398.24.211.165.134.1149723791.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark said:
> Greg Stark <gsstark(at)MIT(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2006-06-07 23:43:43 Re: ADD/DROP INHERITS
Previous Message Mark Woodward 2006-06-07 23:07:55 Re: How to avoid transaction ID wrap