Re: Bug in ALTER COLUMN SET DATA TYPE ?
От | Nikhil Sontakke |
---|---|
Тема | Re: Bug in ALTER COLUMN SET DATA TYPE ? |
Дата | |
Msg-id | CANgU5ZcQohB8ykOptq9ehLWonf6wVBy2xX7WyHPbYyPpN+bxEQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Bug in ALTER COLUMN SET DATA TYPE ? (Pavan Deolasee <pavan.deolasee@gmail.com>) |
Ответы |
Re: Bug in ALTER COLUMN SET DATA TYPE ?
|
Список | pgsql-hackers |
> postgres=# CREATE TABLE test (a float check (a > 10.2));Interestingly, this works in 8.3 and earlier ... but it fails as
> 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
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
--
Postgres-XC Support and Service
В списке pgsql-hackers по дате отправления: