Skip site navigation (1) Skip section navigation (2)

Re: error-free disabling of individual child partition

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Greg Stark <gsstark(at)MIT(dot)EDU>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: error-free disabling of individual child partition
Date: 2006-05-31 19:59:37
Message-ID: 447DF5A9.8040405@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Greg Stark wrote:
>
> Incidentally, did the following message ever make it to the list? I saw my
> carbon copy, but never received it from the list and never received any
> responses. Usually any suggestion of making tokens reserved words elicits
> screams of objections.
>
>
> Greg Stark <gsstark(at)MIT(dot)EDU> writes:
>
>   
>> Tom Lane:
>>
>>     
>>> ALTER TABLE childN DROP INHERITS old_parent;
>>> ALTER TABLE childN ADD INHERITS new_parent;
>>>       
>> I think you would have to make INHERITS a reserved word to make that happen:
>>
>> stark=> create table integer (i integer);
>> CREATE TABLE
>> stark=> alter table test add inherits integer;
>> ALTER TABLE
>>
>>     


Yes it did.

Syntax like this would probably not require making it a reserved word:

 ALTER TABLE foo ALTER INHERITS ADD|DROP bar

Maybe a bit uglier, but not too much.

cheers

andrew



In response to

pgsql-hackers by date

Next:From: Steve AtkinsDate: 2006-05-31 20:08:28
Subject: Re: Possible TODO item: copy to/from pipe
Previous:From: Dave PageDate: 2006-05-31 19:58:49
Subject: Re: Possible TODO item: copy to/from pipe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group