Re: Bug in ALTER COLUMN SET DATA TYPE ?

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: Bug in ALTER COLUMN SET DATA TYPE ?
Дата
Msg-id CABOikdOZPfh932+0myqwS4LPvN0w+-JH6CRMAaJr=zZOxoevKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bug in ALTER COLUMN SET DATA TYPE ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Bug in ALTER COLUMN SET DATA TYPE ?  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Список pgsql-hackers



On Fri, Nov 2, 2012 at 9:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:


In the 8.4 branch, the error is coming from here:

regression=# \set VERBOSITY verbose
regression=# ALTER TABLE test ALTER COLUMN a  TYPE numeric;
ERROR:  42P16: constraint must be added to child tables too
LOCATION:  ATAddCheckConstraint, tablecmds.c:4467

which appears to have been added in commit cd902b331.  I think the
commit Pavan is looking at just moved the logic around.

I also though that for a moment, but the commit that I mentioned did not move that error message from somewhere else. I also tested by resetting to commit 1f0363001166ef6a43619846e44cfb9dbe7335ed (previous to the offending commit) and don't see any error.

But since you're seeing it, may it was taken out by some other older commit and then added back again. Will look more into it  

Thanks,
Pavan

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Proposal for Allow postgresql.conf values to be changed via SQL
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: Bug in ALTER COLUMN SET DATA TYPE ?