> > postgres=# CREATE TABLE test (a float check (a > 10.2));
>> > CREATE TABLE
>> > postgres=# CREATE TABLE test_child() INHERITS(test);
>> > CREATE TABLE
>> > postgres=# ALTER TABLE test ALTER COLUMN a SET DATA TYPE numeric;
>> > ERROR:  constraint must be added to child tables too
>>
>> Interestingly, this works in 8.3 and earlier ... but it fails as
>> described in all later versions.  So we broke it quite some time back.
>> It would be good to identify exactly what change broke it.
>>
>>
> Hmm.. I haven't yet tested on other branches. But I'm surprised that you
> find it broken on so much old branches. "git annotate" suggests that the
> offending error message was added by commit
> 09ff76fcdb275769ac4d1a45a67416735613d04b and that commit is dated Apr 20,
> 2012
>
>

Mea Culpa. I did indeed add that error message. But it's strange when Tom
says that this is broken since 8.3!

Regards,
Nikhils
-- 
StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Service

In response to

• Re: Bug in ALTER COLUMN SET DATA TYPE ? at 2012-11-02 15:07:14 from Pavan Deolasee

Responses

• Re: Bug in ALTER COLUMN SET DATA TYPE ? at 2012-11-02 15:30:22 from Tom Lane

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2012-11-02 15:30:22
	Subject: Re: Bug in ALTER COLUMN SET DATA TYPE ?
Previous:	From: Dimitri Fontaine	Date: 2012-11-02 15:10:17
	Subject: Re: unfixed bugs with extensions