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

Re: I find a bug (IMHO)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Danger Dancer <rigalkin(at)luch(dot)podolsk(dot)ru>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: I find a bug (IMHO)
Date: 2004-02-11 22:04:32
Message-ID: 200402112204.i1BM4Wc20457@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Danger Dancer <rigalkin(at)luch(dot)podolsk(dot)ru> writes:
> > #little example
> > create table a (d int check (d<5));
> > create table b () inherits (a);
> > alter table b drop constraint "a_d";
> 
> I think the bug is that it allowed you to do this.  You should not be
> able to drop an inherited constraint, any more than you can drop an
> inherited column.

Added to TODO:

        o Disallow dropping of an inherited constraint

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2004-02-11 22:29:09
Subject: Re: [BUGS] Bug in pg_autovacuum ?
Previous:From: PostgreSQL Bugs ListDate: 2004-02-11 21:32:50
Subject: BUG #1080: Ref #1045 resolved

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