Skip site navigation (1) Skip section navigation (2)

Re: Bug in ALTER COLUMN SET DATA TYPE ?

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in ALTER COLUMN SET DATA TYPE ?
Date: 2012-11-02 15:07:14
Message-ID: CABOikdMq4RFeHXSjEdaWEWcq+tU9Lxu07QYqaQTB3R7ntvRwag@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, Nov 2, 2012 at 8:11 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> writes:
> > I noticed this behavior on master and it seems like a bug to me:
>
> > 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

Thanks,
Pavan

In response to

Responses

pgsql-hackers by date

Next:From: Dimitri FontaineDate: 2012-11-02 15:10:17
Subject: Re: unfixed bugs with extensions
Previous:From: Dimitri FontaineDate: 2012-11-02 15:05:15
Subject: Re: unfixed bugs with extensions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group