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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Atkins | 2006-05-31 20:08:28 | Re: Possible TODO item: copy to/from pipe |
Previous Message | Dave Page | 2006-05-31 19:58:49 | Re: Possible TODO item: copy to/from pipe |