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

Re: Cascaded Column Drop

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Cascaded Column Drop
Date: 2002-09-27 04:29:21
Message-ID: 1033100962.27772.38.camel@jester (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> > Is that a good idea, or should we refuse the drop entirely?  A table
> > drop zaps a lot more stuff than a column drop.
> 
> I think we should refuse the drop.  It is just too strange.  You can
> suggest if they want the column dropped, just drop the table.

Leaving a zero-width table would be best, even if its not so useful.  I
don't like rejecting a CASCADE as it kinda defeats the purpose of having
CASCADE.

The patch may not work right in complex cases anyway.  It seems the
switch to remove the table should be earlier.

-- 
  Rod Taylor


In response to

Responses

pgsql-hackers by date

Next:From: Jim MercerDate: 2002-09-27 04:31:48
Subject: Re: hacker help: PHP-4.2.3 patch to allow restriction of database access
Previous:From: Tatsuo IshiiDate: 2002-09-27 04:29:19
Subject: Re: unicode

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-09-27 04:46:33
Subject: Re: one last patch - array lower and upper bound
Previous:From: Tom LaneDate: 2002-09-27 04:28:56
Subject: Re: Cascaded Column Drop

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