From: | Nikhil Sontakke <nikkhils(at)gmail(dot)com> |
---|---|
To: | Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Bug in ALTER COLUMN SET DATA TYPE ? |
Date: | 2012-11-02 15:16:23 |
Message-ID: | CANgU5ZcQohB8ykOptq9ehLWonf6wVBy2xX7WyHPbYyPpN+bxEQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-11-02 15:30:22 | Re: Bug in ALTER COLUMN SET DATA TYPE ? |
Previous Message | Dimitri Fontaine | 2012-11-02 15:10:17 | Re: unfixed bugs with extensions |